explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
- 8 Answers
- 35426 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rekha
NORMAL LOAD : IT LOADS THE RECORD ONE BY ONE AND WRITES LOG
FOR EACH FILE . IT TAKES MORE TIME TO COMPLETE
BULK LOAD : I LOAD THE NUMBER OF RECORDS AT A TIME ,IT WONT
FALLOW ANT LOG FILES OR TRACE LEVELS . IT TAKES LESS TIME
USE THE BULK MODE FOR IMPROVING THE SESSION PERFORMANCE
| Is This Answer Correct ? | 49 Yes | 4 No |
Answer / addy
Hi
I would like to mention- apart from logging differences
there is a crucial diffrence - if we are running the session
in bulk target load mode we cant recover a session from the
same point when we run it for the next time.
whereas if we are running the session in normal target load
mode we can recover the session if the output being loaded
to the target is deterministic in nature - this is relay a
helpful feature with the applications handling RealTime data.
-addy
| Is This Answer Correct ? | 31 Yes | 4 No |
Answer / shashank
in the normal loading the taget write all the row on the
database log , while laoading the bulk loading the database
log is not come in the picture (that mean its skip the
property )so when the session got failed we can easily find
recover the seesion by the help of data base log.but in
case of bulk loading we can do .
but normaol loading is very slow as compare to bulk laoding.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / sujith
Above 5,6&7 are the correct for this questions....
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / thiru
In normal loading it will creates the log file before
loading target.it will takes the time but in this sessiom
recovery is available.
In bulk loading the integration service bypasses the log
file,direct load into the target.inthis there is no session
recovery available but performance increase.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / sankar
NORMAL LOADING:THE INTEGRATION SERVUCE CREATE THE DATA BASE
LOG BEFORE LOADING DATA INTO THE THE TARGET DATA BASE.SO
--THE INTEGRATION SERVICE PERFORM ROLL BACK AND SESSION
RECOVERY.
BULK LOADING:THE INTEGRATION SERVICE IN WORK THE BULK
UTILITY WHEN BYPASS THE DATA BASE LOG
--THIS IS IMPROVES THE PERFORMANCE DATA LOADING
--THIS IS NOT PERFORM ROLLBACK
| Is This Answer Correct ? | 6 Yes | 2 No |
1)Bulkload & Narmal load
Normal: In this case server manager allocates the
resources(Buffers) as per the parameter settings. It creates
the log files in database.
Bulk: In this case server manager allocates maximum
resources(Buffers) available irrespective of the parameter
settings. It will not create any log files in database.
In first case data loading process will be time taking
process but other applications are not affected. While in
bulk data loading will be much faster but other application
are affected.
| Is This Answer Correct ? | 12 Yes | 13 No |
Answer / jyothsna katakam
when you select the normal, it will check the p.k and f.k
relation ship while running the mapping but when you select
the bulk it wont check any p.k and f.k relation ship
| Is This Answer Correct ? | 7 Yes | 27 No |
Enlist the tasks for which source qualifier transformation is used.
What are the different types of Type2 dimension maping?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Explain direct and indirect flat file loading (source file type) - informatica
What are the types of lookup?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are some examples of informatica etl programs?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Teradata 
