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
- 14447 Views
- SLK Software, I also Faced
- E-Mail Answers
Answer Posted / naresh
Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable
finally load the data in target.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why fact table is in normal form?
How do you schedule or monitoring the job?
Can we use target hash file as a lookup ?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you explain tagbatch restructure operator?
What is the difference between account and directory options ?
describe the Steps to confiure a Qlogic switch
What are stage variables, derivations and constants?
what is repositery?
Define data aggregation?
How can one find bugs in job sequence?
On which interface you will be working as a developer?
how to implement scd2 in datastage 7.5 with lookup stage
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is a merge?
