How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?
SCD2 will work on only dimension tables as well as fact Table?
what is Forward,Reverse and Re_engineering?
What is a mapping, session, worklet, workflow, mapplet?
What is fact? What are the types of facts?
without using ETL tool can u prepare a Data warehousing and maintaining?
What are various etl tools in the market?
What are the names of the layers in etl?
what are the concerns of OLTP and DSS systems?
what is Forward,Reverse and Re_engineering?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
hoe to access second value in mapping parameter if it is having more than one value ?????????????