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|
What is batch and describe about types of batches?
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
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
any one can informatica metirial to me ple forwrd to my mail id; firstname.lastname@example.org
what is pre and post sql and what is diff between source presql and target pre sql
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
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?
What is the difference between Power Centre and Power Mart?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
what are the row and column separations in Flat Files
Which will beter perform IIf or decode?
Can we use the mapping parameters or variables created in one mapping into another mapping?