Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18

How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.

Answer Posted / bharath

If src have n no. of records then how will u do the same?

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Have you used Unstructured data?

826


How do u convert the columns to rows in datastage?

690


Explain the situation where you have applied SCD in your project?

1558


what is the difference between == and eq in UNIX shell scripting?

972


What are the functionalities of link collector?

623






How many types of sorting methods are available in datastage?

629


What is the difference between passive stage and active stage?

820


How to RD using transformer?

857


Can you implement SCD2 using join, transformer and funnel stage?

1080


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1896


What are the different kinds of views available in a datastage director?

598


How to perform incremental load in datastage?

663


What is the difference between the local container and shared container?

643


How do you import and export data into datastage?

698


Explain the importance of surrogate key in data warehousing?

706