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
What is a quality stage in datastage tool?
How many areas for files does datastage have?
What are datastage sequences?
Define data aggregation?
What are transforms and what is the differenece between routines and transforms?
Differentiate between datastage and informatica?
what is the difference between == and eq in UNIX shell scripting?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
client know skid info?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Give an idea of system variables.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How one source columns or rows to be loaded in to two different tables?
What is the difference between an operational datastage and a data warehouse?
What are the important features of datastage?