my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?

Answer Posted / naga

Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the format of informatica objects in a repository?

605


How does the aggregator transformation handle null values?

708


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1540


What is expression transformation?

641


How can we handle two sessions in informatica?

623






Mention a few design and development best practices for informatica?

568


tell me about your project functionality

1877


Performance tuning in UNIX for informatica mappings?

2154


What are some examples of informatica etl programs?

544


What are the different types of transformation available in informatica.

644


What is joiner transformation in informatica?

632


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

793


Design a mapping to load a target table with the following values from the above source?

889


How many ways are there to create ports?

734


how many types of dimensions are available in informatica?

569