i have source data like
empno,enmae
11 ,aa
12 ,bb
i want output like
empno,ename
11 ,aa
12 ,bb
11 ,aa
12 ,bb
Answer Posted / venugopal
Take source in the sequential file and take two copy stages
and map the columns to two copy stages and use funnel stage
to funnel the data from two copy stages and o/p into the
file now you can see the o/p is your requirement....
Hope this will help you...
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is the difference between an operational datastage and a data warehouse?
Can you explain kafka connector?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Define project in datastage?
What are the types of containers?
What is data partitioning?
How one source columns or rows to be loaded in to two different tables?
How do you reject records in a transformer?
What is orabulk stage?
whom do you report?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the difference between datastage and datastage tx?
Define Merge?
What are transforms and what is the differenece between routines and transforms?
Define APT_CONFIG in Datastage?