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
- 12196 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
What are the functionalities of link collector?
Describe the main features of datastage?
How do y read Sequential file from job control?
What is a datastage job?
Differentiate between validated and Compiled in the Datastage?
How to Remove Duplicate using SQL?
What is merge stage?
How do you reject records in a transformer?
What are the benefits of datastage?
What is the purpose of interprocessor stage in server jobs?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Define Routines and their types?
What is a folder? Difference types of stages?
What are the processing stages?
Explain entity, attribute and relationship in datastage?
