Interested to Buy Any Domain ? << Click Here >> for more details...
souce file having the columns like
name company
krish IBM
pooja TCS
nandini WIPRO
krish IBM
pooja TCS
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
- 9 Answers
- 12270 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit gosain
Hi ALL,
Job Design:
SourceSeqFile--->SortStage--->Transformer--->TgtSeqFile
1. In Sort Stage, take two key, name & company and then go
to options and create a keyChange column.
2. In transformer stage, create a stage variable of integer
type (say Var1) and write in it's derivation:
if keyChange=1 then 1 else Var1+1
3. Now create a new column in tgt (say count) and in
transformer, assign that Var1 to the derivation of count.
4. Goto o/p tab of transformer and there sort the data on
count column.
You'll get the desired output.
If you have more queries, you can mail me on
ankitgosain@gmail.com
Cheers,
Ankit :)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain Quality stage?
What is a merge?
Describe link sort?
Terminate Activity
What all the types of jobs you developed?
What is datastage engine?
To see hidden files in LINIX?
Can you highlight the main features of ibm infosphere information server?
What are the job parameters?
Define meta stage?
what is repositery?
What are stage variables?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Name the different sorting methods in datastage.
What is the sortmerge collector?
