Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rekha
SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
How you can differentiate between connected lookup and unconnected lookup?
What do you understand by SOA of Informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is informatica metadata and where is it stored?
What is substr in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
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?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the command used to run a batch?
Explain pushdown optimization and types in informatica
How to Create a folder using pmrep command?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Whats there in global repository
what is index?how it can work in informatica
