Explain about the data integration suite features?
No Answer is Posted For this Question
Be the First to Post Answer
Explain about hash partitioning?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What do you understand by the term ‘transformation’?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
when should one create lookup transformation ?
What is tracing level? How many types of transformations supported by sorted input?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain about etl data integration software?
what are the facilities provided by data warehouse to analytical users?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?