While migrating the data from one environment to another environment how would you manage the connections?
1090How do you manage the Parameter files while migrating your data from one environment to another environment?
1017Post New Informatica Questions
Define mapplet?
What are the advantages of using informatica as an etl tool over teradata?
Explain the different dimensions.
What are the types of caches in lookup? Explain them.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
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.
Why is sorter an active transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are connected or unconnected transformations?
How do you update the records with or without using update strategy?
How can we use mapping variables in informatica?
What is the different lookup cache(s)?
What is the difference between a connected look up and unconnected lookup?