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

Where do we use mapping variables in informatica?

623


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2433


Explain lookup transformation in informatica

655


Explain lookup transformation is active in informatica

671


What is a router transformation?

640






How would you copy the content of one repository to another repository?

565


How to create the source and target database connections in server manager?

640


What is informatica metadata and where is it stored?

599


What is InformaticaPowerCenter?

700


How many ways a relational source definition can be updated and what are they?

592


Scheduling properties,whats the default (sequential)

1479


Mention some types of transformation?

612


What do you understand by SOA of Informatica?

597


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1333


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2290