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
- 25902 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
How do you take back up of repository?
What are connected or unconnected transformations?
which one is better performance wise joiner or look up
What is a router transformation?
Describe an informatica powercenter?
What is a transaction control transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Define update strategy?
State the differences between sql override and lookup override?
What is informatica? Why do we need it?
Define filter transformation?
What are mapplets?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What will be the approach?
Enlist few areas or real-time situations where informatica is required.
