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
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the functionalities of link collector?
Can we use target hash file as a lookup ?
How do you start developing a datastage project?
What are iconv and oconv?
Describe link sort?
What is active and passive stage?
Could anyone give brief explanation bout datastage admin
Difference between ‘validated ok’ and ‘compiled’ in data stage?
describe the Steps to confiure a Qlogic switch
Where do the datastage jobs get stored?
project Steps,hits, Project level HArd things,Solved methods?
Explain the situation where you have applied SCD in your project?
What is ds designer?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr