Answer Posted / mohit

After running the session once it will load 10000 records
and it will fail afterwards then we can take the minimum
and maximum count of the number of records in the target in
a paramter and we can specify these parameters in the SQl
override of sql qualifier so once again when it will run
the session then it will take those minimum and maximum
values from the parameter and will specify a condition in
the sql overide that dont take any values from min to max
and take rest of the values so in this case the minimum
will be 1 and the maximum will be 10000 so the sql overide
will take the values after 10000 i.e 10001.

select * from employee where value is not in between $$min
and $$max
I think may be this can be a solution

What are the types of data warehouses?

1035

---

How to extract sap data using informatica? What is abap? What are idocs?

676

---

Differentiate between a repository server and a powerhouse?

669

---

What is a snowflake schema?

655

---

What is the difference between a repository server and a powerhouse?

943

---

---

Different qualification between a related rotate toward the sky and isolates look upward?

647

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4408

---

have u done any performance tuning? how u ll do?

1961

---

Repository user profiles

1460

---

where to store informatica rejected data? How to extract the informatica rejected data?

688

---

How do you load unique records into one target table and duplicate records into a different target table?

828

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849

---

What is sequence generator transformation in informatica?

714

---

Define filter transformation?

718

---

What is a joiner transformation?

668

---