1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is a time dimension? give an example?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is a time dimension? give an example?..

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

what is a time dimension? give an example?..

Answer / shaheem qhizer

Example of time dimension is Calender year.

Is This Answer Correct ?    5 Yes 5 No

Post New Answer

More Informatica Interview Questions

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

what is INFORMATICA TESTING process

0 Answers  

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

How are parameters defined in informatica?

3 Answers   HP, TCS,

Where is metadata stored?

0 Answers  




in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

What are the uses of etl tools?

0 Answers  

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories