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 / 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 |
Post New Answer View All Answers
What is "fatal error/rdbms code 3996" error?
Can you filter data in hashed file?
Define meta stage?
Can we use target hash file as a lookup ?
What are transforms and what is the differenece between routines and transforms?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Define Merge?
What is the command line function to import and export the ds jobs?
How do you remove duplicate values in datastage?
Is possible to create skid in dim,fact tables?
How do you generate sequence number in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the stages in datastage?
What is the difference between odbc and drs stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu