What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
817How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1318How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
870I 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.
848Post New Informatica Questions
What is fact table? Explain the different kinds of facts.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
define galaxy repository in informatica
Explain transaction control transformation in informatica
What is incremental aggregation?
Briefly describe lookup transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the advantages of using informatica as an etl tool over teradata?
How many input parameters can exist in an unconnected lookup?
What are the guidelines to be followed while using union transformation?
Repository user profiles
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the settings that you use to configure the joiner transformation?
How can informatica be used for an organization?
What is the procedure for creating independent data marts from informatica 7.1?