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
- 10374 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
What is the advantage of informatica?
What are multi-group transformations?
What does role playing dimension mean?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are session parameters ? How do you set them?
How can we use mapping variables in informatica? Where do we use them?
tell me about your project functionality
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is pmcmd command?
Is there any way to read the ms excel datas directly into informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is parallel processing in informatica?
have u done any performance tuning? how u ll do?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
