Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / kish
Hi,
you can go for partitioning... i dont know exactly the
procedure...but this the way wat i know..... if there is any
clear explanation...it will be great...
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is substr in informatica?
How to call shell scripts from informatica?
How can we remove the duplicates from flat file source?
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
What is informatica? Why do we need it?
How you can differentiate between connected lookup and unconnected lookup?
What is an aggregator transformation?
lookup transformation with screenshots
What is the meaning of up gradation of repository?
Explain sessions. Explain how batches are used to combine executions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How does a rank transform differ from aggregator transform functions max and min?
What is joiner change?
How identifying bottlenecks in various components of informatica and resolving them?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?