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
- 12132 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 |
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
plz tell me some dimentional and fact table names in banking project?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
Can you implement SCD2 using join, transformer and funnel stage?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
what is time dimension? and how to populate time demension
Explain the ChangeApply stage?
What is lookup table?
Teradata 
