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?
1018Post New Informatica Questions
What is the use of an aggregator cache file?
Different circumstance which drives informatica server to expel records?
what is the size of your data warehousing?
How do you load only null records into target?
Explain how to import oracle sequence into informatica?
Explain the scenario which compels informatica server to reject files?
What are the performance considerations when working with aggregator transformation?
How will the document be delivered to me?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Design a mapping to load the cumulative sum of salaries of employees into target table?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the types of lookup transformation?
how we can load rejected record's at run time?(not through bad files)
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are ETL Tools?