What is the difference between Active and Passive transformation?
No Answer is Posted For this Question
Be the First to Post Answer
While importing the relational source definition from the database, what are the metadata of source that will be imported?
explain abt joiner t/r?
write a query to get maximum salary from the employers table without duplicates....kindly help me
what is the diff b/w cached and unchaed look ups
Explain lookup transformation is active in informatica
How to load duplicate records in to a target table which has a primary key?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Hi experts, can anyone tell how much we use plsql in real time
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
How to identify this row for insert and this row for update in dynamic lookup cache
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What is the need of etl tools?