Output1: eid,ename 11,AA 11,CC 11,BB 22,DD 22,BB 22,AA 22,CC 33,EE

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.

Question Posted / saran

1 Answers
5839 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How a server job can be converted to a parallel job?

1096

Could anyone give brief explanation bout datastage admin

2355

Difference between sequential file and data set?

1205

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5124

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

what is the difference between == and eq in UNIX shell scripting?

1500

What is the sortmerge collector?

1132

Define Job control?

1151

What is datastage engine?

1183

What is the difference between hashfile and sequential file?

1262

Describe link sort?

1018

What is meta stage?

1185

Can you define merge?

1128

Differentiate between odbc and drs stage?

1050

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920