1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

major difference between normal loading and bulk loading?

Question Posted / chandrasekar

Answer Posted / chandrasekar

IF WE SELECT THE TARGET LOAD TYPE IS NORMAL, THEN DATA
MOVEMENT IS ROW BY ROW AND STORE AN INSTRUCTIONS IN SESSION
LOG FILE.IF SESSION FAILS, WE CAN RECOVERY THE DATA USING
SESSION RECOVERY AND DATA LOADING IS SLOW. BUT IN BULK TYPE
LOADING DATA IS FAST AND IT DOESN’T MAINTAIN THE SESSION
LOG FILE. IF SESSION FAILS WE CANNOT USE SESSION RECOVERY
IN BULK MODE.

IF I WRONG MEANS PLEASE SEND THE MAIL TO ME
chandranmca2007@gmail.com

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

621

What is union transformation?

571

How to extract the informatica rejected data?

751

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1601

What are connected or unconnected transformations?

628




Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1507

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

2276

Explain what are the different versions of informatica?

655

can we override a native sql query within informatica? How do we do it?

647

Why union transformation is an active transformation?

653

What is joiner transformation in informatica?

625

What is a stored procedure transformation?

610

Explain pushdown optimization and types in informatica

666

How can we use batches?

602

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

771