Answer Posted / rekha
SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
What is union transformation in informatica?
What is flashback table ? Advance thanks
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is substr in informatica?
Informatica settings are available in which file?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
generate date / time dimension in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you load only null records into target?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Describe an informatica powercenter?
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?