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
- 11956 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
Which algorithm you used for your hashfile?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Why do we use link partitioner and link collector in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
How will you move hashed file from one location to another location?
What are the functionalities of link partitioner?
How do you start developing a datastage project?
What is the difference between validated and compiled in the datastage?
Explain the importance of surrogate key in data warehousing?
Highlight the main features of datastage?
What is the process of killing a job in datastage?
Name the third party tools that can be used in datastage?
How do you remove duplicate values in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Define Merge?
