How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / pk
There is a free lesson on the Informatica aggregator
transformation on the home page of trainovation.com
|Is This Answer Correct ?||1 Yes||3 No|
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is the use of dimensional modeling in data warehousing?
Explain degenerate dimension table?
What is the difference between aggregate table and materialized view?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain which are the olap tools available that are supported by oracle?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are snapshots? What are materialized views & where do we use them?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain what is the difference between view filter and report filter?
Can we start and stop single session in concurent bstch?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain the data type of the surrogate key?
Define Data Warehousing?
Explain what are the mapping paramaters and maping variables?