Why touse stored procedure in ETL Application?

Answers were Sorted based on User's Feedback



Why touse stored procedure in ETL Application? ..

Answer / susheel sharma

in our project we used store procedure to implement CDC
(change data capture) for incremental data load.

generaly store procedure used when you have to implement
your complex business logic.

Is This Answer Correct ?    6 Yes 0 No

Why touse stored procedure in ETL Application? ..

Answer / grhyrngnn yjhyj

i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,


What is a repository manager?

0 Answers  


Briefly describe lookup transformation?

0 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


why u go for dimensions ?

3 Answers   TCS,


How can repository reports be accessed without sql or other transformations?

0 Answers  


why union transformation is active transformation?

6 Answers   IndiGo, TCS,


Do you have to change the reject file b4 using reject loader utility.

1 Answers  


What is meant by query override?

0 Answers  


Categories