What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
1140How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1648How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
1182I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
1225Post New Informatica Questions
What is a node in Informatica?
How do you load only null records into target?
Which are the different editions of informatica powercenter that are available?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Tell me about Propagate functions in informatica
What is different between the data warehouse and data mart?
Why update strategy and union transformations are active?
What do you mean by worklet?
What do you mean by enterprise data warehousing?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the advantages of informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
4 yrs etl devloper roles and responsibilities?any body give solutions