what is session partitioning?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is an ETL or ETT? And what are the different types?
how do u extract data from different data sources explain with an example?
what are the reporting tools and difference between them?
how do u identify the changed records in operational data?
what are the facilities provided by data warehouse to analytical users?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
if you use oracle sql*loader , how do you transform data with it during loading?
what are the others of "bad files" and "discard files" when using sql*loader?
what are the other factors of the database on which the loading performance depend?
what is parallel query?
what are different storage options supported by oracle ?
can anybody tell me about complicated object you have created
how many reports have u created ? explain a few.