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
- 12326 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
What are the stages in datastage?
Name the different sorting methods in datastage.
Name the command line functions to import and export the DS jobs?
What is the difference between hashfile and sequential file?
What are the important features of datastage?
What is the roundrobin collector?
What are the partitioning techniques available in link partitioner?
What are datastage sequences?
What are the various kinds of containers available in datastage?
What is the flow of loading data into fact & dimensional tables?
What are the repository tables in datastage?
What are the different plug-ins stages used in your projects?
What is a quality stage in datastage tool?
What is ds designer?
How to convert RGB Value to Hexadecimal values in datastage?
