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.



IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC..

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

Post New Answer

More Data Stage Interview Questions

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,


i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  


How do you schedule or monitoring the job?

0 Answers  


What are stage variables, derivations and constants?

0 Answers  


what about data stage requirement

1 Answers  






i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,


Differentiate between hash file and sequential file?

0 Answers  


Define orabulk and bcp stages?

0 Answers  


How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,


How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  


Categories