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?

Answer Posted / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different components of powercenter?

578


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)

1073


can you please explain me pre session and post session options?

6357


Differentiate between Load Manager and DTM?

1657


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1653






Which version configuration tool used in ur project?

2762


What is DR strategy for Informatica project?

692


What is the format of informatica objects in a repository?

593


What is a pre-defined event and user-defined event?

573


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1444


What are the main features of Oracle 8i with context to datawarehouse?

1673


What are the types of lookup transformation?

627


What is decode in informatica?

648


What is an unconnected transformation?

659


What is the benefit of session partitioning?

589