How to Delete Dataset in Datastage Parallel Jobs?
Latest Answer: We can delete dataset using DataStage designer Client.Tools -> DataSet Management We can select dataset and delete it. ...
A sequential file has 8 records with one column, below are the values in the column separated by space,1 1 2 2 3 4 5 6In a parallel job after reading the sequential file 2 more sequential files should
Latest Answer: We can segregate the file into two files by using AGGREGATOR stage. One file with records having count 1 and the other file with records having count more than 1. In the properties tab of AGGREGATOR stage select the Aggregation type as  "Count Rows" ...
With a Lookup stage the input stage has 1million records and reference link has 1million records. What is the best Partition method and why?
Latest Answer: When the reference link is too high in terms of records fetched, you should be performing a join instead of performing a lookup ...
How can you say that performance will be improve if we make use of a dataset?Why does the performance degrade when we use 4-5 transformers in a single job?
Latest Answer: Dataset are referring to control file due to this dataset will give fast performance while processing the data, if you use transformers in job, it should compile the C++ backend due to this datastage engine will get more pressure to handle transformer ...
How do we set up nodes in Datastage?
Latest Answer: Here not the question of admin or developer.For the above question we have provide proper answer, like Go to DS manager and create nodes into Configuaration file according to the requirement. Please if any of DS admin registered expecting step by step ...
What are these terms used for in Datastage - Downstream and Upstream?
Latest Answer: Upstream -> ETL -> Downstream.ETL : Extract , Transform and Load. In current context, ETL is done through Data Stage application.Downstream : This refers to all the applications/processes which are going to consume the output of ETL.Upstream: ...
Explain Wrapped, Build and Custom stages?
Latest Answer: Custom: This allows knowledgeable Orchestrate users to specifyan Orchestrate operator as a DataStage stage. This is then availableto use in DataStage Parallel jobs.Build: This allows you to design and build your own bespokeoperator as a stage to be included ...
What is Orchestrate Schema? Distinguish internal data type (Orchestrate schema) vs external data type
I am working on Datastage. Can any body tell me how to work on repeating fields and multiple headers.
Latest Answer: We should create some staging variable & define the value for repeating fields there & then just map these to respective columns. ...
how technical design will be prepared in datastage?
Latest Answer: If you want to prepare a design doc, then you should know the complete flow of your project along with business rule. Technical design doc is nothing but the flow of the process, to describe in jobs. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
