what is the logic will you implement to load data into a
fact table from n dimension tables?
Answer Posted / elango
fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How might one distinguish in the case of mapping is right or not without associating session?
Can we create two repositories on same database instance in oracle?
How can repository reports be accessed without sql or other transformations?
How to load last n records of file into target table - informatica
What is an unconnected transformation?
What are the tuning techniques you applied during your last project
Implementation methodology
How many numbers of sessions can one group in batches?
can we override a native sql query within informatica? How do we do it?
what is the hint? how to use it to reduce the query processing in program?
How to update source definition?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica etl tool?
What is the surrogate key?