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

Can you explain kafka connector?

1241

Define Routines and their types?

1095

What is the use of datastage director?

970

What is the difference between passive stage and active stage?

1412

How to read the length of word in unix?

1310

What are the processing stages?

1037

On which interface you will be working as a developer?

985

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2175

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3732

What are routines in datastage? Enlist various types of routines.

1047

Enlist various types of routines in datastage.

1185

What are the components of ascential data stage?

1110

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2405

What are the primary usages of datastage tool?

1016

How you Implemented SCD Type 1 & Type 2 in your project?

4072