Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12465 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 are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
What are the rank caches?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
How many number of sessions that u can create in a batch?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
What are mapplets? How is it different from a Reusable Transformation?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What are the types of presistent cache in look up tr.
How we can create indexes after completing the loan process?
What are the designer tools for creating tranformations?
Where can we find the throughput option in informatica?
Plz can any one say me how to get the informatica certification materials and dumps
Teradata 
