what is data modelling? what are types of modelling?In
which suituation will use each one?
- 1 Answers
- 12668 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / mike
Data modelling: It is the process of designing a a datamart
or dataware house. there are three phases in data modeling
1)conceptual designing:In this phase the database
architects and the managers will understand the client
requirements. After understanding the requirements they
will identify the attributes and entities(colomns and
tables)
2)Logical designing:In this phase the dimension tables and
the fact tables are identified and also the relation ship
between the fact and dimension tables will gets identified.
Now the schema looks like either a star or snowflake
schema. To perform logical designing we use data modelling
tools like ER STUDIO or ERWIN.
3)Physical designing: Once the logical designing is
approved by the client it will be converted in to physical
existance in the database.
Hope this helps
| Is This Answer Correct ? | 23 Yes | 0 No |
can you use flat file for lookup table?why?
what is system requirement(SR) & business requirement(BR)?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
What are the different types of schemas?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
why union transformation is active transformation?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Difference between session variables and workflow variables?
Briefly define a session task?
Teradata 
