Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 47014 Views
- I also Faced
- E-Mail Answers
Answer Posted / hania
Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.
Disadvantages: Dimension table have greater rows, large fact table
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What you know about transaction control transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the reusable transformations?
What is an expression transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Briefly define reusable transformation?
What is meant by a domain?
Did u used latest transformations of 8.6.0? for what?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can we use mapping variables in informatica? Where do we use them?
What is rank transformation?
Please let me know how to make encryption and decryption with example?
