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


Please Help Members By Posting Answers For Below Questions

What is a quality stage in datastage tool?

867


How many areas for files does datastage have?

893


What are datastage sequences?

912


Define data aggregation?

893


What are transforms and what is the differenece between routines and transforms?

859


Differentiate between datastage and informatica?

975


what is the difference between == and eq in UNIX shell scripting?

1222


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

2045


client know skid info?

1886


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1897


Give an idea of system variables.

814


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2212


How one source columns or rows to be loaded in to two different tables?

926


What is the difference between an operational datastage and a data warehouse?

896


What are the important features of datastage?

853