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
- 26099 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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Can we get 1st record through Informatica(without sequence number).
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is Cognos script editor?
What are the popular informatica products?
What is target designer and target load order?
What is joiner change?
Describe an informatica powercenter?
What are the components of workflow manager?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the issues you have faced in your project? How did you overcome those issues?
How to delete duplicate row using informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Differentiate between Load Manager and DTM?
