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
- 12557 Views
- I also Faced
- E-Mail Answers
Answer Posted / pushparaj
Just modified the last post with minor changes
First sort the both name and compamy and then,
using stage variable in transformer:
sv1= name:company
sv3=if sv1=sv2 then sv3+1 else sv3(initial value of sv3=1)
sv2=sv1(initial value of sv2 =XXXXXXX)
OP
name company count=sv3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is a folder? Difference types of stages?
What are stage variables, derivations and constants?
Can you implement SCD2 using join, transformer and funnel stage?
What is apt_config in datastage?
How to reverse the string using unix?
Define Job control?
How rejected rows are managed in datastage?
Does datastage support slowly changing dimensions ?
What are the various kinds of the hash file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between datastage and informatica?
How do you import and export the datastage jobs?
How to clean the datastage repository?
What are the types of hashed files in data stage
