Interested to Buy Any Domain ? << Click Here >> for more details...
What is the procedure to load the fact table.Give in
detail?
- 1 Answers
- 8834 Views
- I also Faced
- E-Mail Answers
Answer / dr.journalist
Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.
| Is This Answer Correct ? | 2 Yes | 4 No |
What are Dimensional table?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
Can u generate reports in Informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
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.
What is transformation?
What are the guidelines to be followed while using union transformation?
How can yoU create or import flat file definition in to the warehouse designer?
Where do you create/define mapping parameter and mapping variable?
What are set operators in Oracle
what are objects in data warehouse?
Teradata 
