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
- 12303 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
What is the purpose of interprocessor stage in server jobs?
How you Implemented SCD Type 1 & Type 2 in your project?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Can you highlight the main features of ibm infosphere information server?
How to find value from a column in a dataset?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are constraints and derivations?
What could be a data source system?
What are system variables and sequencers in datastage
What is the use of datastage designer?
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 active and passive stage?
What is the difference between validated and compiled in the datastage?
What is the method of removing duplicates, without the remove duplicate stage?
how to write server Routine coding?
