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 mean by flag 4 in update strategy t/r

6 Answers  


S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  


My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,






What is up date strategy and what are the options for update strategy?

2 Answers  


What is powercenter on grid?

0 Answers  


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


disable caching in a lookup transformation?

1 Answers  


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


What are the different ways to implement parallel processing in informatica?

0 Answers  


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


Categories