what is a time dimension? give an example?
- 2 Answers
- 11762 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 |
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is correlated query?
What are the modules in Power Center
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
how to get max value record into one target and remaining records into another target?
What is the difference between bitmap and btree index?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
can any one explain me about junk dimension
HOW DO YOU CONNECT TO REMOTE SERVER ?
What is an expression transformation?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Teradata 
