What are the different types of schemas?
Answer Posted / kalyan
3types of schems:
Star Schema (As above)
Snow Flake Schema (As above)
Galaxy or Integrated or Fact Constellation Schema ( By
which, a dimensional table is shared by one or more Fact
tables )
Good Luck.
| Is This Answer Correct ? | 40 Yes | 16 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
How do you change a non-reusable transformation to reusable transformation?
How can we use batches?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Differentiate between sessions and batches?
What are the different versions of informatica?
What are active transformations.
How many ways are there to do 'remove duplicate records in informatica'?
Explain the code page compatibility?
Have you worked with/created Parameter file
How you prepared reports for OLAP?
How can one identify whether mapping is correct or not without connecting session?
what is index?how it can work in informatica
explain one complex mapping with logic? sales project?