Eliminating of duplicate records without using dynamic lookups
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a lookup table in etl?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
can be used COM component in Informatica ?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
what are the reporting tools and difference between them?
Mention few test cases and explain them?
how would u estimate the size of Aggregator transform data and index cache?
What is etl process. How many steps etl contains explain with example?