I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Answer Posted / ks316
Hi all,
I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.
I think there should be a condition to every group in the
router.
i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,
pls correct me if i am wrong
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is rank transform?
How many ways are there to create ports?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How does the aggregator transformation handle null values?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is pmcmd command?
What are the main issues while working with flat files as source and as targets ?
What are the static cache and dynamic cache in informatica?
What is decode in informatica?
How to do unit testing in informatica?
Do you find any difficulty while working with flat files as source and target?
What are the different versions of informatica?
Differences between version 7.x and 8.x.
What does “tail –f” command do and what is its use as an Informatica admin.
Write the unconnected lookup syntax and how to return more than one column.