Loading Techniques in ETL at Database end

Informatica Interview Questions and Answers, Informatica Real time Issues and Scenarios.

Loadinig Techniques in ETL Loading at Database end.

Answer: There are two Type of Loading Techniuqs while Loading data into Database tables.

1. Direct Load

2.Conventional Load

Direct Load:

Data will be Loaded first into table and then it will check the Constarints defined on the table.

it will be faster loading.

Conventional Loading:

Data will loaded into table after Checking the Constraints defined on the table. if the data saticifies the Constarint Conditions then only data will be Loaded into table. otherwise it will not load and job will fail.

compared with Direct loading Conventional Loading is little slow but Safer in Loading.

Direct Loading, if we have any data issues then we need to Clean the table to correct the Bad data. becuase the data will be loaded before constraint checking.

in Conventional loading,if we have any data issues then data will not be loaded into table. before loading data it will fail.

Thanks,

Anilkumar.