Explain the scenarios where sequential file stage runs in parallel?
Answers were Sorted based on User's Feedback
Scenario -
When we have to read the data from multiple files following the same format, we can enable this option (multiple reader)
thanks
www.datagenx.net
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vijay
Yes - parallely
No - Sequentially(This is default value)
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / naresh
Hi,
In seqential file stage _under_options _______ read for mulitible nodes - yes/no
Yes___ seqentially
No____ parallel
| Is This Answer Correct ? | 5 Yes | 9 No |
what is a nodemap constraint
What is the difference between datastage and datastage tx?
on how many columns we can perform aggregation in the aggregator stage?
Where do you see different stages in the designer?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Name the different sorting methods in datastage.
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
how to identifie,is it innerjoin,leftouter join in lookup?
Differentiate between Join, Merge and Lookup stage?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
What are the functionalities of link partitioner and link collector?