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
- 10875 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / gopal
In the transformer stage u can use concatination symbol for
first two records like Record1 : Record2 this is for first
column and second column u mentioned as it is.
| Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
Explain usage analysis in datastage?
What are the components of datastage?
What is the difference between hashfile and sequential file?
What steps should be taken to improve Datastage jobs?
Lookup constraints
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...
Which algorithm you used for your hashfile?
How can you write parallel routines in datastage PX?
Can you explain kafka connector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Name the different types of Lookups in Datastage?
Highlight the main features of datastage?
What are the different layers in the information server architecture?
What are the steps needed to create a simple basic datastage job?
What are the different kinds of views available in a datastage director?
