What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
1081How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1583How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
1125I 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.
1167Post New Informatica Questions
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to elaborate powercenter integration service?
Explain the difference between mapping parameter and mapping variable?
During the running session, output files are created by informatica server. Enlist few of them.
Design time, run time. If you don't create parameter what will happen
What are the mapping parameters and mapping variables?
Does an informatica transformation support only aggregate expressions?
What is an expression transformation in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Briefly explain the aggregator transformation?
What will be the approach?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the differences between oltp and olap?
Different sorts of metadata that stores in the storage facility?
What is the difference between informatica 7.0 and 8.0?