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
- 11211 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 |
which dim, fact tables used in bank domain
What is a datastage job?
How to generate surrogate key without using surrogate key stage?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
what is .dsx files
how to convert rows into columns
What is the use of hoursfromtime() function in transformer stage in datastage?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
What are the third party tools you used in your project?
Teradata 
