What are the basic requirements to join two sources in a source qualifier transformation using default join?
1130Post New Informatica Questions
Mention few advantages of router transformation over filter transformation.
What is data transformation manager process?
What does reusable transformation mean?
Can we create multiple integration service on single repository?
What happens when a session fails and you click on recover?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain about Informatica server process that how it works relates to mapping variables?
What is substr in informatica?
What is an Integration service in Informatica?
What is different between the data warehouse and data mart?
How do we call shell scripts from informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the mapping parameters and mapping variables?
What are session parameters ? How do you set them?