Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sai suresh
SCD: Slowly changed dimention
The SCD how to Capture the change data with respect to the
time. For ex: In an organization emp sal is chaged
according to his perfomence after chaned sal we kept in
datawarehouse. (Datawarehouse maintain a Historical data )
there are 3 types of SCDs.
Type1: It will maintain curren data only. It does't
maintain historical data.
Type2: It maintain current and historical data.
Type3: It maintain current and previous data it mease
Parcial data only maintain.
So generelly datawarehouser is maintain Historical data
hence Type 2 is useful
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is informatica metadata?
Name the different lookup cache(s)?
explain about unit testing? in real time?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to improve the performance of a session using sorter transformation?
When do you use sql override in a lookup transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Which transformation is needed while using the Cobol sources as source definitions?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
COM components can be used in Informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Write the unconnected lookup syntax and how to return more than one column.
What is update strategy transform?
