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 / praveen
You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What is the status code in stored procedure transformation?
where to store informatica rejected data?
Why sorter is an active transformation?
What is informatica? Why do we need it?
What are the types of schemas we have in data warehouse.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Is it possible to create multiple domains on a single Informatica server?
What is session task and command task?
Explain the shared cache and re-cache?
Explain about Informatica server process that how it works relates to mapping variables?
What are the advantages of informatica?
what is the complex transformation you used in informatica
How to open an older version of an object in the workspace?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?