Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vaibhav bhandeo
Data modelling requires understanding of the requirements.
In general the design of data model can be a snowflake
(Highly normalized) or star schema (partial or not
normalized) which depends on whether you want optimal
utilization of space (Use star schema) or you want a
normalized data model easy to query and acess data (Use
snow flake).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do you mean incremental aggregation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
how to load rows into fact table in data warehouse
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How many ways a relational source definition can be updated and what are they?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
how many types of dimensions are available in informatica?
How can we delete duplicate rows from flat files?
What will be the approach?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is the -ve test case in your project.
What is the need of etl tools?
What are the mapping parameters and mapping variables?
