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
- 12219 Views
- I also Faced
- E-Mail Answers
Answer Posted / shasank, pr3systems
use transforemr stage and give three stage variable with intial value as 0,
then give (if company=ibm then count=count+1 else stgvar1)
like give three conditions for remaing two companies in two stage variables)
and in column derivation give if company=ibm then stgvar1 else
if company=wipro then stgvar2 else if company=tcs then stgvar3 else 0(company not in list)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
What is the method of removing duplicates, without the remove duplicate stage?
How to manage date conversion in Datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Define project in datastage?
Can you explain kafka connector?
How do you import and export data into datastage?
Is the value of staging variable stored temporarily or permanently?
What is a quality stage in datastage tool?
Define Data Stage?
What is the difference between validated and compiled in the datastage?
Explain the importance of surrogate key in data warehousing?
How a routine is called in datastage job?
How the ipc stage work?
How many types of views are there in a datastage director?
