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

Explain ibm infosphere information server and highlight its main features?

614


what is ds administrator used for?

725


What is staging variable?

625


What is the purpose of pivot stage?

610


How many types of hash files are there?

613






What could be a data source system?

581


Explain the situation where you have applied SCD in your project?

1566


why do u need the IOS upgradation in a FC switch

1875


How to perform incremental load in datastage?

673


What is a datastage job?

624


What is datastage engine?

731


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

1657


how can we create rank using datastage?what is the meaning of rank?

8192


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2708


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

1754