Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15 Answers
- 26093 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain sessions. Explain how batches are used to combine executions?
Which files are created during the session rums by informatics server?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Clarify the utilization of aggregator cache record?
What is target load order?
How many transformations can be used in mapplets.
What is blocking transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the differences between joiner transformation and source qualifier transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
difference between repository database and repository service?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Is it possible to revert a global repository to local one and why?
How does a sorter cache works?
What is an expression transformation?
