Interested to Buy Any Domain ? << Click Here >> for more details...
explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
- 8 Answers
- 36954 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 |
What is CDC? How to implement CDC?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What is factless fact schema?
How can you complete unrcoverable sessions?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
Is it possible to define a single node as a Gateway node as well as worker node?
How do you take care of security using a repository manager
What is data merging,data cleansing,sampling?
 Informatica Checkpoints
Teradata 
