Interested to Buy Any Domain ? << Click Here >> for more details...
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS
EID,ENAME
11,AA
11,CC
22,DD
33,EE
22,AA
22,BB
22,CC
11,BB
THEN i SELECT perform sort ON eid,uncheck both
unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT
I CAN GET.what happend if i select UNIQUE,STABLE.
PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
- 1 Answers
- 5788 Views
- I also Faced
- E-Mail Answers
Answer / saran
Output1:
eid,ename
11,AA
11,CC
11,BB
22,DD
22,BB
22,AA
22,CC
33,EE
Output2:(stable)
eid,ename
11,AA
11,CC
11,BB
22,DD
22,AA
22,BB
22,CC
33,EE
Output3:(unique
eid,ename
11,AA
22,DD
33,EE
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
What are routines in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
how to run jon in unix back round process what is command use in runing a job?
which memory is used by lookup and join
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How can we improve performance of data stage jobs?
Wat is pre-load in Hashed file
Teradata 
