Hanu Ch Rao

• Mar 2nd, 2007

 

Hi,
In Informatica there are mainly 2 types of loading is there.
1. Normal
2. Bulk
you say and one more Incremental Loading.

Normal means it loads record by record and writes logs for that. it takes time.
Bulk load means it loads number of records at a time to target - it ignores logs ignores tracing level. It takes less time to load data to target.

Ok...

sreedhark26

 Profile Answers by sreedhark26 

• Mar 5th, 2007

 

2 type of loading

1. Normal
2. Bulk

Normal loading creates database log, it is very slow
Bulk loading by passes the database log, it is very fast
it disable the constraints.

sanghala

 Profile Answers by sanghala Questions by sanghala

• Mar 9th, 2007

 

Hanu,

I agree with you.

You told about Incremental Loading.

Can u please let me know in detail about this type of Loading??????

Thanks in advance..........

sreedhark26

 Profile Answers by sreedhark26 

• Mar 12th, 2007

 

Loadings are 3 types

1. One time data loading
2. Complete  data loading
3. Incremental loading

veerachalla

• Mar 13th, 2007

 

Two Types

 Normal  :Data retrival is very easy it creates a index
 Bulk       : Data retrival is not possible it stores the data in improperway

harikr

 Profile Answers by harikr 

• Dec 20th, 2009

 

sanghala,

      Incremental load means loading only the new records from the source into the target. This can be achieved by a process called incremental aggregation.

Suppose a source has 8000 rows one day , u load it to target. The next day, 50 rows get added to the source and u want to get only those new 50 rows, u can use incremental loading.

When you use incremental aggregation, you need to configure both mapping and session properties:

♦Implement mapping logic or filter to remove pre-existing data.

♦Configure the session for incremental aggregation and verify that the file directory has enough disk space for the aggregate files.

Anonymous

• Jul 21st, 2016

 

Can we know what type of loader is used by Informatica to load data in to Oracle database?

saiteja

• Jul 24th, 2017

 

There are 2 types of loading in the Informatica
1) Normal load
2) Bulk load

When you configure the load as normal load it process the row by row the normal uses log file for restartability

When you configure load type as bulk load all the records are loaded parallely and it increases the performance but it does not contain log file