Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12601 Views
- IBM, I also Faced
- E-Mail Answers
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 power center repository?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
what is the diff b/w cached and unchaed look ups
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
what is curr val use for in sequence generator?
what is the incremental agrrigation?
What are the Differences between static cache and dynamic cache?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
How to update records in Target, without using Update Strategy?
Different types of Power center errors?
How many ways are there to do 'remove duplicate records in informatica'?
what are the deliverables?in your project?
Teradata 
