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
5810 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

tell me abt Datastage trigger?

1 Answers HP, IBM,

what r the stages mostly used in realtime scenarios

4 Answers HCL, IBM,

How did you reconcile source with target?

3 Answers HP,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers IBM,

In merge stage can we update the values?

3 Answers TCS,

how to create document in datastage?

1 Answers Cap Gemini,

What is RCP

5 Answers CGI, CTS,

how to do pergformence tuning in datastage?

4 Answers MCA, Symphony, TCS,

I have a few records just I want to store data in to targets cycling way how?

0 Answers Polaris,

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?

2 Answers

In which situations we can use normal and sparse lookup stages

4 Answers IBM,

How to add zero "0" before record in a field?

4 Answers

For more Data Stage Interview Questions Click Here