What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
1015How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1506How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
1057I 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.
1102Post New Informatica Questions
write a query to retrieve the latest records from the table sorted by version(scd)
Briefly define reusable transformation?
tell me 5 session failure in real time how can you solve that in your project?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is meant by active and passive transformation?
How to update or delete the rows in a target, which do not have key fields?
What is aggregator transformation in informatica?
What are junk dimensions?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is incremental aggregation?
What are the components of workflow manager?
How will the document be delivered to me?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is domain in terms of informatica?