Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12735 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 calculate the optimum cache size in aggregator transformation?
how to sort date field in infomatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
tell me 7.x and 8.x diferrencess(but not transformations)
Write the unconnected lookup syntax?
How many ways are there to create ports?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What is workflow? What are the components of workflow manager?
How will you update the first four rows and insert next four rows in a mapping?
what are the real time problems generally come up while doing or running mapping or any transformation?
Teradata 
