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
- 12025 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 could be a data source system?
What is meta stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Lookup constraints
How many types of views are there in a datastage director?
What is the sortmerge collector?
What are the different type of jobs in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
AGGREGATOR default datatype
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define project in datastage?
What is the differentiate between data file and descriptor file?
What is oci?
Nls stands for what in datastage?
What is merge stage?
