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
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
How to start a workflow using pmcmd command?
What does update strategy mean, and what are the different option of it?
How can we improve session performance in aggregator transformation?
wat are deployement groups in informatica, how it will be used for developers
how many types of dimensions are available in informatica?
Write the prerequisite tasks to achieve the session partition?
Where are the source flat files kept before running the session?
Explain what transformation and how many are there in informatica?
What is rank transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain in detail scd type 2 through mapping.
What do mean by local and global repository?
Define mapping and session?
How do you set a varible in incremental aggregation