Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.
- 1 Answers
- 4300 Views
- I also Faced
- E-Mail Answers
Answer / rao
Firstly we have to load the dimension tables.from dimension
tables take the primary key reference and load the Fact table.
That mean if you have dimensions like product,branch,customer,
we load product id,branch id,customer id(only surrogate keys)
to fact table .later measure will be loaded.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is substr in informatica?
What is an expression transformation in informatica?
difference between repository database and repository service?
how many data models u have done in informatica project?
In informatics server which files are created during the session rums?
What is dimensional table? Explain the different dimensions.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What are the differences between joiner transformation and source qualifier transformation?
Enlist the advantages of informatica.
Sequence generator, when you move from develoment to production how will you reset
What aer the out put files that the informatica server creates during the session running?
Teradata 
