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 ..

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

Mention some types of transformation?

0 Answers  

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

What is joiner transformation?

0 Answers  

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

How the Informatica Server reads perameter file?

1 Answers  

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

What is data merging, data cleansing and sampling?

6 Answers   Satyam,