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
Answers were Sorted based on User's Feedback
Answer / satyanarayana
take one copy stage and then take two output links from copy
stage and next these two o/p links given to funnel stage and
provide option called 'sequential mode' in funnel stage then
you will get req output.
Is This Answer Correct ? | 18 Yes | 3 No |
Answer / 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 |
Answer / raj
Hello Chowdary... Using one source file only not two source
files he is asking first look into the question and answer
in the proper way...
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / amit
read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rambabu
from sequential file connect copy stage
from capy take 2 o/p links and these o/p links conn to 2
transformer stages
next take funnel stage
in funnel set property funnel type=seq i thionk this is
solutions
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / chowdary
Take 2 sequentalfiles target dataset and processing funnel
stage.
note: Take similar structure we need common column names,
common datatypes then merging this process.....
Is This Answer Correct ? | 1 Yes | 6 No |
How to use Environment variable's in datastage?(use of process)
what are the devoleper roles in real time? plz tell i am new to datastage....
Whats difference betweeen operational data stage (ods) and data warehouse?
whats relation between configuration file and datasets?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
What are the different options associated with dsjob command?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the steps needed to create a simple basic datastage job?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?