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
- 11547 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 |
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What is the scenario which compels informatica server to reject files?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
What do you understand by term role-playing dimension?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Different sorts of metadata that stores in the storage facility?
what is persistant cache in which situation we will use persistantcache
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Teradata 
