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 / mike

src-->source qual--->exp--->router--->target

based on the conditions we can use other trn's

correct me if i was wrong

Is This Answer Correct ?    7 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a rank transform?

670


What is informatica etl tool?

548


Enlist the tasks for which source qualifier transformation is used.

582


can u give example for factless fact table

5507


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1843






How many number of sessions can one group in batches?

684


Explain sql transformation in script mode examples in informatica

597


What is fact table? Explain the different kinds of facts.

610


What is a snowflake schema?

563


What are multi-group transformations?

556


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1458


What is source qualifier transformation in informatica?

569


What are the transformations that are not supported in mapplet?

593


What is the difference between a repository server and a powerhouse?

801