Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 31059 Views
- Informatica, Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answer Posted / sandeep.t nizamabad
DIMENSIONS ARE CLASSIFIED INTO THREE TYPES
SCD TYPE-1 (MAINTAIN CURRENT DATA)
SCD TYPE-2 (MAINTAIN CURRENT DATA+FULL HISTORY OF CHANGES)
SCD TYPE-3 (MAINTAIN CURRENT DATA+ONE TIME HISTORY)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What is informatica metadata and where is it stored?
Where are the source flat files kept before running the session?
How many transformations can be used in mapplets.
How to open an older version of an object in the workspace?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is size of u r database?
What is workflow manager?
Briefly define a session task?
What are data-driven sessions?
Enlist few areas or real-time situations where informatica is required.
What is the difference between Active and Passive transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Mention few power centre client applications with their basic purpose?
What is a surrogate key?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
