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
- 14287 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
If you want to use the same piece of code in different jobs, how will you achieve it?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How to reverse the string using unix?
What are routines in datastage?
how can we create rank using datastage?what is the meaning of rank?
how to implement scd2 in datastage 7.5 with lookup stage
What are the areas of application?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Difference between server jobs & parallel jobs?
How many types of hash files are there?
Does datastage support slowly changing dimensions ?
how to add a new records into source?
What are the stages in datastage?
How rejected rows are managed in datastage?
What is staging variable?
