Interested to Buy Any Domain ? << Click Here >> for more details...
Why touse stored procedure in ETL Application?
- 2 Answers
- 11928 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Have you worked with/created Parameter file
How do you load only null records into target? Explain through mapping flow.
How will you combine 3 different sources with a single source?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What are the new features of Power Center 5.0?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
what is dynamic cashe
What are differences between Informatica 7.1 and 6.1
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
What are the join types in joiner transformation?
define galaxy repository in informatica
Teradata 
