what is a time dimension? give an example?
Answers were Sorted based on User's Feedback
Answer / sri ram
Time Dimension:Generally, to generate dates as per the
requuirement we use date dimension.
If your loading of data in fact table on the basis of
time/date then we use the values of date dimension to
populate the fact.
we take the last date on which the fact is populated. Then
check for the existence of dates for the data to be
populated.ifnot we generate through some stored procedure
or as per requirement.
Eg:Daily,weekly,financial year, calender year, business
year etc.,
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / shaheem qhizer
Example of time dimension is Calender year.
Is This Answer Correct ? | 5 Yes | 5 No |
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
performance wise which one is better in joiner and lookup transformation
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
If we set dd_insert in mapping and Delete in session properties what will happen.?
How to eliminate duplicates in FF and oracle both
What is the benefit of session partitioning?
How to delete duplicate record in Informatica?
Which is the best place to learn Informatica Powercenter Online Training?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the difference between unicode & ascii mode data movement in informatica?
why we are using surogate key in real time give me explanation