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

Answer Posted / kish

Hi,

you can go for partitioning... i dont know exactly the
procedure...but this the way wat i know..... if there is any
clear explanation...it will be great...

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

641


What is workflow manager?

579


Which transformation should we use to normalise the COBOL and relational sources?

748


Performance tuning( what you did in performance tuning)

1489


What are the advantages of using informatica as an etl tool over teradata?

569






Why filter transformation is an active one?

565


what is Active lock explain

2374


How are indexes created after completing the load process?

989


How can we use mapping variables in informatica? Where do we use them?

621


What is difference between a gateway node and worker node?

630


Mention few power centre client applications with their basic purpose?

540


What is the status code in stored procedure transformation?

689


Is it possible to revert a global repository to local one and why?

615


Can we get 1st record through Informatica(without sequence number).

992


Which are the different editions of informatica powercenter that are available?

562