What is a data modeling?
Answers were Sorted based on User's Feedback
Answer / raju2
data modelling means breaking entity relation between
tables and bulid up of d/w using schemas by dimensional
modelling
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jeevan kumar medapati
this is the process of designing the data base.in real time
data base architech (or) data modeler design the data base
by using GUI base data base designing tool ERVIN.
3 types of data models can be defined (1)star data model
(2)snoflake data model
(3)galaxy data model
| Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
tell me the rules and responsblites in our project(my project is development)
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How many ways are there to do 'remove duplicate records in informatica'?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How do you load unique records into one target table and duplicate records into a different target table?
What is meant by query override?
Which is better performance wise database or file?How?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?