Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
can u any challenge your project?
What is incremental aggregation?
Have you worked with/created Parameter file
How to join three sources using joiner?
Mention some types of transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain pushdown optimization and types in informatica
What is a pre-defined event and user-defined event?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Define joiner transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What does command task mean?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
