list and discuss two approaches for updation of target table
in Informatica and how they are different.
- 0 Answers
- 1885 Views
- I also Faced
- E-Mail Answers
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
explain the methodology of Data Warehousing?(Polaries)
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How many steps etl contains?
Do we need an ETL tool? When do we go for the tools in the market?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
How many types of transformations supported by sorted input?
what is session partitioning?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
What is Relational Integrity?
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?
Teradata 
