Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 batch and describe about types of batches?

2 Answers  

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

any one can informatica metirial to me ple forwrd to my mail id;

1 Answers  

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

what are the row and column separations in Flat Files

3 Answers   CTS,

Which will beter perform IIf or decode?

3 Answers   TCS,

Can we use the mapping parameters or variables created in one mapping into another mapping?

0 Answers   Informatica,