Interested to Buy Any Domain ? << Click Here >> for more details...
what is a time dimension? give an example?
- 2 Answers
- 12741 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 is the difference between IN and Exists in Oracle?
how to get flatfile containg 10 records half records one target another half another target
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a node in Informatica?
how will compare two mappings in two different repository?
Write the advantages of partitioning a session?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
What are the limitations of joiner transformation?
What is workflow? What are the components of the workflow manager?
can we generate reports in informatica ? How?
Teradata 
