Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
1866Post New Informatica Questions
What is Session and Batches?
without table how to come first record only in oracle?
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 a pre-defined event and user-defined event?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Repository user profiles
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is informatica metadata and where is it stored?
What is different between the data warehouse and data mart?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the Methods For Creating Reusable Transformations?
What is the fact table?
What all are steps in up gradation of Informatica server?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain sessions and how many types of sessions are there?