Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12503 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 can one come to know wether the records loak into the target if we use update strategy
Define mapping and session?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to update or delete the rows in a target, which do not have key fields?
what is the complex transformation you used in informatica
What is difference between maplet and reusable transformation?
Filter transformation in the condition one of the data is NULL would the record be dropped.
what is the use of Data Mart?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
What is meant by incremental aggregation?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
In real time scenario where can we use mapping parameters and variables?
Teradata 
