Answer / archie

Sri has just said the oposite

Answer / rajasekar genji

yes Archie is right has the name indicates bulk, data will
loaded has bulk we cannot recover in bulk. In Normal mode
data will be loaded one by one so data can be recovered.

Answer / priya

Normal mode creates a session log and is used in session
recovery.
But in Bulk mode its faster in peformance but its not
possible to create a session recover.

Answer / nivas

Target Loading types are mainly catagorized into 2 types
1.Normal Loading
2.Bulk Loading

In the permoance Point of view Bulk Loading is better than
Normal Loading but session recovery is not possible because
of it's Byparses the session log.

Normal loading create the session log for session recovery.
Using Normal Loading only we will get session recovery.

Answer / pardhu

when u configure the session with the type normal the I.S
writes the data records to database log before inserting the
rows into target. when u configure the session with the type
bulk the I.S bypasses the database log it inserts the
records directly into target. In normal mode session
recovery is possible but in bulk mode session recovery is
not possible. bulk mode improves the performance.

Answer / guravareddy

When u chose target load type Normal mode the integration service creates database log and is used in session
recovery.
Where as in bulk mode the integration service by pass load the data into target, but its not
possible to create a session recover.
But in Bulk mode its faster in peformance.

Answer / kumar

Hi Friends,

Normally we have two types of loading. 1, Normal and 2. Bulk.

1 Normal: in this, data will load record by record and the integration service creates database log and is used in session because IS maintain the session log.

2 Bulk: In this, Data will insert Group of records, obviously bulk load will give better performance.

thanks,
kumar

Answer / sri

Bulk mode always create a session log and is used in
session recovery for eg . if we opt for bulk mode, if the
session fails after inserting 9000 rows on total of 10,000
rows (commit interval is after 10,000 rows) then we can
recover 9000 rows and can satrt the session for the rest of
row
In normal mode session log is not created and hence it is
faster than bulk mode .. Session recovery is not possible
in normal mode ..

Differentiate between sessions and batches?

0 Answers  

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?

0 Answers  

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

task is running successfully but data is not loded why?

2 Answers  

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

Insert else update option in which situation we will use

4 Answers   HCL,

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

How can you complete unrcoverable sessions?

1 Answers  

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,