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
- 12268 Views
- I also Faced
- E-Mail Answers
Answer Posted / abc
we can use aggregator stage.. nad group on the basis of name and company...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the components of ascential data stage?
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
How can you write parallel routines in datastage PX?
What are some prerequisites for datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is the use of skid in reporting?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the various kinds of the hash file?
Why fact table is in normal form?
how to write server Routine coding?
What are the areas of application?
How do y read Sequential file from job control?
What all are the different way to run a job?
What is the use of datastage director?
Difference between data warehousing and olap?
