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
- 26573 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ganesh
First declare variable parameters start value =0 and end
value=1000. Then, connect sour > seq > filter > target.
assign the seq start value = start value and end value = end
value. it will pass first 1000 records. next time increment
the variable parameter by 1000 for both start and end value.
then, it will send the next 2000 records. then, do the same
process for the remaining.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
What can we do to improve the performance of informatica aggregator transformation?
What is rank transformation in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Mention few power centre client applications with their basic purpose?
How many ways a relational source definition can be updated and what are they?
Differentiate between Load Manager and DTM?
What is Data Caches size?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
without table how to come first record only in oracle?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Performance tuning in UNIX for informatica mappings?
What do mean by local and global repository?
On which transformations you created partitions in your project?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
