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 |
deptno wise to find max and min,and sum of rows and in target to company wise maximum
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
What is the precedence of stage variables,derivations, and constraints?
Can you explain repository tables in datastage?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
What are routines in datastage? Enlist various types of routines.
Define meta stage?
What a datastage macro?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
What are the types of views in datastage director?