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
- 12210 Views
- I also Faced
- E-Mail Answers
Answer Posted / disney
first sort the both name and compamy and then,
using stage variable in transformer:
curr= name:company
val=if curr <> prev then 1 else val+1
prev=curr
o.p = val
name,company,val
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Distinguish between informatica & datastage. Which one would you choose and why?
Difference between sequential file and data set?
Difference between server jobs & parallel jobs?
What are the stages in datastage?
What is the purpose of pivot stage and types of containers in datastage
How to clean the datastage repository?
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.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Describe link sort?
how to abort the job its matain duplicates?
What are the functionalities of link partitioner?
what is ds administrator used for?
Explain how a source file is populated?
What is a quality stage in datastage tool?
Where do you see different stages in the designer?
