source file having the data like aabbccc, i want target file
result like a1a2b1b2c1c2c3.
Answer Posted / ramki
The same logic we can implement for as per the below Q
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
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain ibm infosphere information server and highlight its main features?
what is ds administrator used for?
What is staging variable?
What is the purpose of pivot stage?
How many types of hash files are there?
What could be a data source system?
Explain the situation where you have applied SCD in your project?
why do u need the IOS upgradation in a FC switch
How to perform incremental load in datastage?
What is a datastage job?
What is datastage engine?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
how can we create rank using datastage?what is the meaning of rank?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
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