What is decode in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is joiner transformation in informatica?
what is unit testing?tell me proceedure
What is expression transformation?
What is a rank transform?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain how to import oracle sequence into informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the mapping variable usage example in informatica
What's the layout of parameter file (what does a parameter file contain?)?
What do you mean by channel change?
Explain why we use partitioning the session in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between informatica 7.0 and 8.0?