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
- 11953 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
how to sort two columns in single job in datastage.
What is the difference between orabulk and bcp stages?
Define ds designer?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How you can fix the truncated data error in datastage?
What is the difference between hashfile and sequential file?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the benefits of datastage?
Demonstrate experience in maintaining quality process standards?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is size of a transaction and an array means in a datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are constraints and derivations?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
