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 a quality stage in datastage tool?
What could be a data source system?
How do you import and export the datastage jobs?
Differentiate between operational datastage (ods) and data warehouse?
How to reverse the string using unix?
What are the different kinds of views available in a datastage director?
What are the types of hashed files in data stage
Enlist various types of routines in datastage.
Have you used Unstructured data?
What are the different common services in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Why we use surrogate key?
Differentiate between datastage and informatica?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is meta stage?