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
Have you used Unstructured data?
How do u convert the columns to rows in datastage?
Explain the situation where you have applied SCD in your project?
what is the difference between == and eq in UNIX shell scripting?
What are the functionalities of link collector?
How many types of sorting methods are available in datastage?
What is the difference between passive stage and active stage?
How to RD using transformer?
Can you implement SCD2 using join, transformer and funnel stage?
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)
What are the different kinds of views available in a datastage director?
How to perform incremental load in datastage?
What is the difference between the local container and shared container?
How do you import and export data into datastage?
Explain the importance of surrogate key in data warehousing?