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 |
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
Explain the situation where you have applied SCD in your project?
in oracle target stage when we use load option and when we use upsert option?
How a source file is populated?
Is there any possibility to generate alphanumeric surrogate key?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
Differentiate between Join, Merge and Lookup stage?
What could be a data source system?
Explain briefly scd type2 in datastage7.5x2(parallel)
How to create user defined environment varibale(parameter)?
What is size of a transaction and an array means in a datastage?