Interested to Buy Any Domain ? << Click Here >> for more details...
i have input like this
Column 1 ,column 2
3,a
4,b
5.c
i want output
aaa
bbbb
ccccc
Ple help any one?
- 4 Answers
- 14442 Views
- SLK Software, I also Faced
- E-Mail Answers
Answer Posted / geetha
use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are some prerequisites for datastage?
Nls stands for what in datastage?
Difference between data warehousing and olap?
Why do we use exception activity in Datastage?
Give an idea of system variables.
What are the steps required to kill the job in Datastage?
What all are the different way to run a job?
What steps should be taken to improve Datastage jobs?
How do you import and export data into datastage?
What are transforms and what is the differenece between routines and transforms?
How do you reject records in a transformer?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the difference between server job and parallel jobs?
