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.
Answer Posted / 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 |
Post New Answer View All Answers
How many areas for files does datastage have?
How you can fix the truncated data error in datastage?
which r the connectors used in san?
Can you explain tagbatch restructure operator?
I have a few records just I want to store data in to targets cycling way how?
What are the types of views in datastage director?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Explain connectivity between datastage with datasources?
What is the purpose of interprocessor stage in server jobs?
Define APT_CONFIG in Datastage?
Describe routines in datastage? Enlist various types of routines.
what is 'reconsideration error' and how can i respond to this error and how to debug this
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance