Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
Answer Posted / boopalan venugopal
THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How does a sorter cache works?
Explain what is informatica metadata and where is it stored?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain scd type 3 through mapping.
What is a dimensional model?
Explain how many types of dimensions are available in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What do think which one is the better joiner or look up?
What are the different lookup cache(s)?
What are the differences between joiner transformation and source qualifier transformation?
What is the sql query overwrite in source qualifier in informatica
What are batches?
What is rank transformation?
Clarify the aggregator change?