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

How do you register plug-ins?

776


what are the errors,warnings in datastage

2399


Define APT_CONFIG in Datastage?

857


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3219


In Datastage, how you can fix the truncated data error?

862


How a server job can be converted to a parallel job?

867


What could be a data source system?

763


What is meta stage?

937


What are the types of containers?

921


How do you generate sequence number in datastage?

847


What are the different plug-ins stages used in your projects?

849


how many rows sorted in sort stage by default in server jobs

3762


What are some different alternative commands associated with "dsjob"?

895


What are iconv and oconv?

994


What are the partitioning techniques available in link partitioner?

2034