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
- 4405 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 |
How we can create indexes after completing the load process?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
How to go to the older version for a mapping?
What are the different types of repositories created using informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Which kind of index is preferred in DWH?
what is the process of target load planing?
Design a mapping to load a target table with the following values from the above source?
How we will implement Pushdown Optimization and Types in Informatica with better examples
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
Teradata 
