What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
601How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1001How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
629I 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.
630Post New Informatica Questions
Why union transformation is an active transformation?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What does command task mean?
What is workflow? What are the components of the workflow manager?
What is rank transformation?
Can we create two repositories on same database instance in oracle?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is informatica metadata and where is it stored?
What is target designer and target load order?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the function of look up transformation?
What do you mean by blocking transformation?
What is pmcmd command?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Define enterprise data warehousing?