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.
- 1 Answers
- 4924 Views
- I also Faced
- E-Mail Answers
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 |
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
what is initial load and incremental load
Tell me Wt main advantage of Stage varibles? Project level hints?
project Steps,hits, Project level HArd things,Solved methods?
Define Data Stage?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Explain usage analysis in datastage?
which dim, fact tables used in bank domain
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Teradata 
