4)
source target
c1 c1 c2 c3
c2 c4 c4 c5
c3 c6 c7
c4
c5
c6
c7
please send me answer this question my mail
- 1 Answers
- 4296 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
1. SRC---->TFM---->TGT1,TGT2,TGT#
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
C1 1
C2 2
C3 3
c4 4
c5 5
c6 6
c7 7
in TFM,
put below condition for each target link.
TGT1--->MOD(ROWNUM,3)=1
TGT2--->MOD(ROWNUM,3)=2
TGT3--->MOD(ROWNUM,3)=0
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
Why do we use exception activity in Datastage?
How can you write parallel routines in datastage PX?
What are transforms and what is the differenece between routines and transforms?
How do you start developing a datastage project?
What are the different layers in the information server architecture?
What are the important features of datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the use of datastage designer?
Is it possible to query a hash file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How do you remove duplicate values in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
table actions available in oracle connector?
how to write server Routine coding?
