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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what are 3 tech challenges/ common issues you face?
what is Active lock explain
What is a repository? And how to add it in an informatica client?
pmscmd startworkflow -sv
tell me 5 session failure in real time how can you solve that in your project?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the different lookup cache(s)?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are different types of transformations available in informatica?
What is difference between a gateway node and worker node?
How to handle decimal places while importing a flatfile into informatica?
where to store informatica rejected data?
