How an expression transformation differs from aggregator transformation?
What is target update override
Why update strategy and union transformations are active? Explain with examples.
scd methodology?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are the different components of powercenter?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
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?
What is aggregate cache in aggregator transforamtion?
how can we use sorter transformation in joins?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.