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
- 22178 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 lookup transformation?
What is the use of code page?
Under what condition selecting sorted input in aggregator may fail the session?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the different types of olap? Give an example?
What is a sorter transformation?
What is data caches/ index caches?
Which files are created during the session rums by informatics server?
How you prepared reports for OLAP?
What is an expression transformation?
how many types of dimensions are available in informatica?
What is an Integration service in Informatica?
Can you use flat files in Mapplets.
What is the difference between stop and abort in informatica
Which is the t/r that builts only single cache memory?
