Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 13008 Views
- Teradata, I also Faced
- E-Mail Answers
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
What are the types of containers?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
What are transforms and what is the differenece between routines and transforms?
What are the different types of lookups in datastage?
How you can fix the truncated data error in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Which commands are used to import and export the datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are orabulk and bcp stages?
Differentiate between data file and descriptor file?
What are the types of hashed files in data stage
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Difference between sequential file and data set?
What is difference between server jobs & parallel jobs?
