⟩ Explain How many types of dimensions are available in Informatica?
There r 3 types of dimensions
1.star schema
2.snowflake schema
3.glaxy schema
3 types.That are
1. SCD(slowly changing dimension) type1
2. SCD type2
3. SCD type3
Question and Answer:
Home Informatica Data Warehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Code the tables statement to produce a multi-level frequency?
How to CREATE an external dataset with sas code?
What is option year cuttoff in sas?
Suppose date is 05sep2005; i want the output like 05sep2005000000 ; how it will come?
Suppose a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window. How can we do this one?
What is the use of catalog?
Suppose a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
What is validvarname and varnum? why we are using this options; explain with a syntax for this options?
In PROC PRINT, can you print only variables that begin with the letter “A”?
Tell me why did you leave your previous job? Why do you want to work for our company?
