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

How to start a workflow using pmcmd command?

0 Answers  

What does role playing dimension mean?

0 Answers  

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

How will u pas the data with out debugger?

4 Answers  

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

Write the unconnected lookup syntax?

0 Answers  

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

Explain the different lookup methods used in informatica?

0 Answers