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
Explain why we use partitioning the session in informatica?
How to use procedural logic inside infromatica?
Explain the pipeline partition with real time example?
How do you migrate data from one environment to another?
Explain lookup transformation is active in informatica
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 .
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Which development components of informatica have the highest usage?
What are mapplets? How is it different from a Reusable Transformation?
Why filter transformation is an active one?
What is a stored procedure transformation?
What is the format of informatica objects in a repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to extract sap data using informatica?
What do you mean by enterprise data warehousing?
