What are slowly changing dimensions?
- 5 Answers
- 28867 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 mean by complex business rule ?
What is the way to execute pl/sql script using informatica mapping?
How do you load only null records into target? Explain through mapping flow.
explain abt ur project architecture?
What is the difference between a connected look up and unconnected lookup?
tell me 5 session failure in real time how can you solve that in your project?
What is the need for an etl tool?
What you know about transaction control transformation?
What is standalone command task?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
tell me the rules and responsblites in our project(my project is development)
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Can we change Dynamic to Static or Persistent cache? If so what happens?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How we can use union transformation?
