Interested to Buy Any Domain ? << Click Here >> for more details...
source file is having 5 records while moving into target it
want to be 10 records
- 4 Answers
- 11587 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
Hi This is Rajesh. use copy stage for multiple copies.From that take 2 links to funnel n load to target ...u wil get 10
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / srikanth
it's not a big issue create a one more node extra and select
the partition entire and run the job
thanks & regards
sriaknth.k
9573056597
| Is This Answer Correct ? | 5 Yes | 4 No |
Different ways are:
1. SRC-->COPY-->(2links)-->FUNNEL-->TGT
from copy stage get 2 copies of output data and send to funnel.
2. SRC-->Transfermer-->(2links)-->FUNNEL-->TGT
in the TFM, map the all the columns to both the links and then funnel them.
3. SRC--->TGT(with append mode)
Run job 2 times with TGT Seq file mode as "Append"
4. 2 SRCs(2 same Seq file Stages)-->Funnel-->TGT
read the same file from 2 Seqfile Stages and send them to funnel.
5. SRC--->TGT
Add 2 "File" properties in the Seq file stage and for both of them give the same file name and path.
File=directory/file.txt
File=directory/file.txt
| Is This Answer Correct ? | 1 Yes | 0 No |
How to read multiple files using a single datastage job if files have the same metadata?
What is use Array size in datastage
Why do you need stage variables?
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?
Define oconv () and iconv () functions in datastage?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what is ds administrator used for?
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.
How many jobs in ur project? Explain any complex job u have done in ur project?
Why fact table is in normal form?
Teradata 
