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 |
What is the Difference between SetVariable and setmaxvariable in informatica?
explan ur project architecture?
How to handle decimal places while importing a flatfile into informatica?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Why you use repository connectivity?
what is meant by data driven.. in which scenario we use that..?
diffrence between command task and control task
What is the use of incremental aggregation?
tell me about your project functionality
How can we store previous session logs?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
How many input parameters can exist in an unconnected lookup?