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 / 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 |
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?
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?
How do you schedule or monitoring the job?
What are stage variables, derivations and constants?
what about data stage requirement
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?
Differentiate between hash file and sequential file?
Define orabulk and bcp stages?
How to generate surrogate key without using surrogate key stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to create environments and call them? What is the use defined variables?
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