Answer Posted / tamil
There few columns like, Invoice Number in Invoiceing Module
and Track number in Logistic modules and Vin Number in Car
manufacture module and some descriptions we can not
maintain in the dimensions since there could be huge number
of unique values. Insteade of mainitaing it in the
dimension, we would need to be place it in the associated
fact table for reporting purpose.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
Explain about cumulative Sum or moving sum?
How can you validate all mappings in the repository simultaneously?
What is the need of an ETL tool?
What is rank transform?
Define filter transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is dynamic cache?
Reusable transformation and shortcut differences
Define mapping and session?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the types of data warehouses?
What is aggregator transformation in informatica?
Describe data concatenation?
What is a connected transformation?