Hi, i did what you mentioned in the answer, i.e. source- >Transformer ->

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.

Question Posted / amjad.mohammed

1 Answers
5671 Views
CGI, I also Faced
E-Mail Answers

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam abl..

Answer / venkatesh

at final it becomefs collecting method in datset.
so we prefer order collection method

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Data Stage Interview Questions

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers Wipro,

how to find diff between 2 dates without using Icon... funtions?

1 Answers

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers IBM,

What is a ds designer?

0 Answers

How we can convert rows to columns in datastage?

4 Answers IBM,

how to run jon in unix back round process what is command use in runing a job?

2 Answers HSBC,

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers Amdocs,

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers TCS,

What is ibm datastage flow designer?

0 Answers

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers Alpharithm Technologies,

what is parameterset?

4 Answers Wipro,

For more Data Stage Interview Questions Click Here