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
complex mapping ur project u r invlve can u explain and give real time example give me ?
Write the unconnected lookup syntax and how to return more than one column.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is size of u r database?
How to use pmcmd utility command?
Briefly define reusable transformation?
What are Dimensional table?
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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the measure objects?
How would you copy the content of one repository to another repository?
How many transformations can be used in mapplets.
How to create Target definition for flat files?
Mention few power centre client applications with their basic purpose?
