Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kshatri
There are again types of modeling:
Data modeling,
Dimension Modeling,
Multidimensional Modeling
Physical Model
Locial Model
Data Modeling: Data modeling is the process of designing a
data base model. In this data model data will be stored in
two types of table fact table, dimension table fact table
contains the transaction data, and dimension table contains
the master data
Dimensional Modeling: It is a logical design technique that
seeks to present the data in a standard, intuitive
framework that allows for high-performance access. There
are different data modelings concepts like ER Modeling
(Entity Relationship modeling), DM (Dimensional modeling),
Hierarchal Modelling, Network modelling.But popular are ER
and DM only
During the logical design phase, you defined a model for
your data warehouse consisting of entities, attributes, and
relationships. The entities are linked together using
relationships.
During the physical design process, you translate the
expected schemas into actual database structures. At this
time, you have to map:
• Entities to tables
• Relationships to foreign key constraints
• Attributes to columns
• Primary unique identifiers to primary key
constraints
• Unique identifiers to unique key constraints
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
Can you generate sequence numbers without using the sequence generator transformation?
What are the main issues while working with flat files as source and as targets ?
Explain load alternative records / rows into multiple targets - informatica
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Describe the impact of several join conditions and join order in a joiner transformation?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
What is a joiner transformation and why it is an active one?
differences between service based and product based?
How many transformations can be used in mapplets.
what is $$$$?
What does refresh system mean, and what are its distinctive choice?
What is the difference between a repository server and a powerhouse?
What is workflow monitor?
