If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?

Answer Posted / basu

I think his question is, he wants to loads incremental. so you can go for Change data capture by using mapping variable/parameters in the SQ query overid

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1404


How to start a workflow using pmcmd command?

711


What does update strategy mean, and what are the different option of it?

588


How can we improve session performance in aggregator transformation?

672


wat are deployement groups in informatica, how it will be used for developers

1252






how many types of dimensions are available in informatica?

559


Write the prerequisite tasks to achieve the session partition?

640


Where are the source flat files kept before running the session?

624


Explain what transformation and how many are there in informatica?

482


What is rank transformation?

577


Different qualification between a related rotate toward the sky and isolates look upward?

551


Explain in detail scd type 2 through mapping.

611


What do mean by local and global repository?

701


Define mapping and session?

584


How do you set a varible in incremental aggregation

1442