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
Explain the types of lookup transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is source qualifier transformation in informatica?
how we can load rejected record's at run time?(not through bad files)
How to do the error handling of if ur source is flatfiles?
What is the Rank index port in Rank transformation?
Enlist some properties of sessions.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the use of source qualifier?
Tell me about MD5 functions in informatica
What is olap (on-line analytical processing?
State the differences between sql override and lookup override?
Explain the different dimensions.
What is the function of aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
