What are slowly changing dimensions?
Answer Posted / ande
there are three types SCD:
type-1: in this we can over write original recourd with new
record
type-2: we can create new record
type-3: we can create new attribute
regards,
ande
| Is This Answer Correct ? | 9 Yes | 23 No |
Post New Answer View All Answers
Can we get 1st record through Informatica(without sequence number).
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How many dimensions are there in informatica?
How is union transformation utilized?
Which development components of informatica have the highest usage?
What is aggregate cache in aggregator transformation?
What is meant by LDAP users?
How can repository reports be accessed without sql or other transformations?
Can you use flat files in Mapplets.
How do we call shell scripts from informatica?
How we can create indexes after completing the load process?
Which are the different editions of informatica powercenter that are available?
What are session parameters ? How do you set them?
Where are the source flat files kept before running the session?
Enlist the differences between database and data warehouse.