suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer Posted / ramesh

src--->Exp--->Seq--->Rtr---->tgt
in sequence generator we will get a key and in rtr we will
mention condition

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Target increases every day even though no new record was inserted

1102


Partition, what happens if the specified key range is shorter and longer

2027


Briefly describe lookup transformation?

596


What is the format of informatica objects in a repository?

593


How to update or delete the rows in a target, which do not have key fields?

647






What is decode in static cache?

586


Write the program through which the records can be updated?

507


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1615


What is the meaning of up gradation of repository?

1384


What is complex mapping?

631


What are the issues you have faced in your project? How did you overcome those issues?

1908


Explain the different lookup methods used in informatica?

578


How you prepared reports for OLAP?

1145


What could be the possible resons of locks by user?

657


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1633