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
- 7 Answers
- 11287 Views
- TCS, I also Faced
- E-Mail Answers
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 exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
How do u call shellscript/Batch file from DS?
How to remove blank spaces from data?
difference between function and procedure...
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
how to sort two columns in single job in datastage.
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.
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are operators in datastage?
Teradata 
