Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.
Answer Posted / 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 |
Post New Answer View All Answers
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Please let me know how to make encryption and decryption with example?
What are the main issues while working with flat files as source and as targets ?
What is substr in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to load last n records of file into target table - informatica
Briefly define reusable transformation?
What are the tasks that source qualifier perform?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is a shortcut and copy in Informatica and how two are different with each other?
What is a surrogate key?
How to configure mapping in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me