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 |
State the difference between an operational datastage and a data warehouse?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
What are the prerequisites for join stage
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Notification Activity
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
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?
What is RCP?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
Explain Quality stage?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
What is Cleanup Resources and when do you use it?