Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradeep
scd-slowly changing dimension
It is the capturing the slowly changing data which changes
very slowly with respect to the time. for example: the
address of a custumer may change in rare case. the address
of a custumer never changes frequently.
there are 3 types of scd. type1 - here the most recent
changed data is stored
type2- here the recent data as well as all past data
(historical data) is stored
trpe3- here partially historical data and recent data are
stored. it mean it stores most recent update and most recent
history.
As datawarehouse is a historical data, so type2 is more
usefull for it.
(welcome new answers)
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Does an informatica transformation support only aggregate expressions?
What is primary and backup node?
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?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Can you generate sequence numbers without using the sequence generator transformation?
Plz can any one say me how to get the informatica certification materials and dumps
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is INFORMATICA TESTING process
Explian the Process of deployment groups in informatica
How is union transformation utilized?
How to do unit testing in informatica? How to load data in informatica ?
What is meant by lookup transformation?
What is an Integration service in Informatica?
How to handle decimal places while importing a flatfile into informatica?
