Interested to Buy Any Domain ? << Click Here >> for more details...
How the facts will be loaded? explain
- 2 Answers
- 8195 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen kumar reddy
LOADING FACTS
The most important thing about loading fact tables is that
first you need to load dimension tables and then according
to the specification the fact tables.
The fact table is often located in the center of a star
schema, surrounded by dimension tables. It has two types of
columns: those containing facts and other containing foreign
keys to dimension tables.
* A typical fact table consists of: Measurements:
additive-measures that can be added across all dimensions ,
non-additive cannot be added and semi-additive can be added
across few dimensions.
* Metrics
* Facts - The fact table has frequently more than one
measurement field and then each field is called a fact.
Usually one fact table has at least three dimension tables.
Note:
Found this answer at http://www.etltools.org/loading/facts.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain reference cursor?
Informatica and datawarehousing courses in Pune?
Slowly changing dimensions, types and where will you use them
What is informatica? What exactly are the practical uses in real world
In which circumstances that informatica server creates Reject files?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
when will we go for unconnected lookup transformation in Informatica?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Teradata 
