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
Define data aggregation?
What is datastage engine?
What are routines in datastage?
Define APT_CONFIG in Datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the processing stages?
Define oconv () and iconv () functions in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Explain ibm infosphere information server and highlight its main features?
How do you schedule or monitoring the job?
How do you remove duplicate values in datastage?
How to find value from a column in a dataset?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
client know skid info?