Hi, i did what you mentioned in the answer, i.e. source-
>Transformer -> 3 datasets. Iam able to see the data in
datasets but its not sort order... Can you tell how sort
the data?? i also checked Hash partition with performsort.
Answer / venkatesh
at final it becomefs collecting method in datset.
so we prefer order collection method
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you design PX Routines ?
How can we do null handling in sequential files?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
What is the differentiate between data file and descriptor file?
Can you implement SCD2 using join, transformer and funnel stage?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
What is meta stage?
what is datastage job Monitoring
DataStage Scenario based Interview Questions
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?