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
- 25547 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 identifying bottlenecks in various components of informatica and resolving them?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the function of union transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different options available for update strategy?
What is the session task and command task?
What is event and what are the tasks related to it?
How can we delete duplicate rows from flat files?
Explain informatica architecture - version 8 / 9
How do you convert single row from source into three rows into target?
How to do the error handling of if ur source is flatfiles?
What is the function of aggregator transformation?
What are multi-group transformations?
What is decode in static cache?
