Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11375 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manthiramoorthy. g
SQ-->EXP-SEQ-RTR-TARGETS
Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / mayur
SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandra
SQ--->EXP-->ROUTER---->TARs
In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets
| Is This Answer Correct ? | 3 Yes | 3 No |
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
What is informatica metadata and where is it stored?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How can we eliminate duplicate rows from flatfile,explain?
What is olap (on-line analytical processing?
Informatica and datawarehousing courses in Pune?
What is source qualifier?
Explain the aggregator transformation?
What is the need of etl tools?
What are the session parameters?
How the dimensions will be loaded?
Teradata 
