in what type of scenario bulk loading and normal loading we use?

Answer Posted / venkateshmalneni

We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786


waht type of interface is used for testing the data in informatica

1837


What is depict expression change?

623


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1626


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9169






Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1625


Is there any target staging area in informatica not staging area

2132


complex mapping ur project u r invlve can u explain and give real time example give me ?

1845


wat are deployement groups in informatica, how it will be used for developers

1262


Explain the different lookup methods used in informatica?

590


What are the components of workflow manager?

590


What is the need of an ETL tool?

644


How many types of sessions are there in informatica.please explain them?

678


How do you change a non-reusable transformation to reusable transformation?

600


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1907