Answer Posted / mahesh
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Describe expression transformation?
Explain scd type 3 through mapping.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Enterprise data warehouse your projects phase by phase explain?
What is a sequence generator transformation?
What is informatica metadata and where is it stored?
What are the tasks that source qualifier perform?
Explain load alternative records / rows into multiple targets - informatica
Which transformation should we use to normalise the COBOL and relational sources?
Define filter transformation?
Differences between version 7.x and 8.x.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Informatica settings are available in which file?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
