Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12494 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 |
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a shortcut and copy in Informatica and how two are different with each other?
How to join three sources using joiner? Explain though mapping flow.
what is distinct
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
HOW TO GET THE LATEST DATA IN SCD ?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can i set break points in debugging mode ? can explain steps please?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
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 JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
Teradata 
