Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy
now i want o/p like this
1 Srinivasa
2 reddy
could u please help in this
Thanks in advance.
Answer Posted / satya
Make U r source file as SOURCE and LOOKUP Files then
Make lookup on key(in u r question first column),if u find
then concatination of u r source value and u r look up VALU
(Srini:Vasa)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Terminate Activity
How do you schedule or monitoring the job?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the different plug-ins stages used in your projects?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are routines in datastage? Enlist various types of routines.
What is merge stage?
What a datastage macro?
Define ds designer?
Highlight the main features of datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between orabulk and bcp stages?
how to delete one row in target dataset
I have a few records just I want to store data in to targets cycling way how?
What are the types of containers in datastage?