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
- 12298 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
use aggregator stage take count(*) group by name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is datastage engine?
What is difference between symmetric multiprocessing and massive parallel processing?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to reverse the string using unix?
What is use Array size in datastage
What is the use of datastage director?
What are the partitioning techniques available in link partitioner?
What are the enhancements made in datastage 7.5 compare with 7.0?
how many rows sorted in sort stage by default in server jobs
what is repositery?
On which interface you will be working as a developer?
Define project in datastage?
What are the functionalities of link partitioner?
What is the difference between operational data stage (ods) and data warehouse?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
