major difference between normal loading and bulk loading?
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
Why sorter is an active transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain transaction control transformation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is aggregator transformation in informatica?
Write the unconnected lookup syntax and how to return more than one column.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Define mapping and session?
Define joiner transformation?
What is aggregate cache in aggregator transformation?
What is a difference between complete, stop and abort?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain direct and indirect flat file loading (source file type) - informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is joiner transformation?