Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12714 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 |
why we use parameters instead of hard code in datastage
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How a server job can be converted to a parallel job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
how to delete one row in target dataset
What is the difference between hashfile and sequential file?
WHAT are unix quentios in datastage
What is the flow of loading data into fact & dimensional tables?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
Teradata 
