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
- 12311 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 some prerequisites for datastage?
What are the different options associated with dsjob command?
which r the connectors used in san?
Is the value of staging variable stored temporarily or permanently?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the types of containers in datastage?
Is possible to create skid in dim,fact tables?
Can you explain engine tier in information server?
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
On which Dimension Table you implemented SCD Type in your Project
What is the process of killing a job in datastage?
how to abort the job its matain duplicates?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain the importance of surrogate key in data warehousing?
What are system variables and sequencers in datastage
