in which situations do u go for scds ?
Answers were Sorted based on User's Feedback
Answer / purva
Slowly changing dimensions are dimension tables that have
slowly increasing dimension data, as well as updates to
existing dimensions.
Ex : if a person Mr. x is living in the city C1 has a
transaction in a bank and his details is maintained and
after some years he moves to city C4, that means he has his
new details develped but the bank need to maintain the
details i.e both c1 and c2 details ,the history has to be
maintained fully or sometimes partially , so in this cases
the necessity of SCD is required
When updating existing dimensions, you decide whether to
keep all historical dimension data, no historical data, or
just the current and previous versions of dimension data.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / murali
Mr.Chandra,
SCD's are the essential mappings we need to useto maintain
Datawarehouses. Coz,if we are serving our clients with
maintainance, we ought to update their data with necessary
changes. the changes can be,
1. Inserting the data from the latest OLTP database
2. Updating our OLAP DWH with changes.
3. Maintaing the change, as well as Historical data etc...
All these, can be done using SCD's only...
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rajan raorane
SCDs are basically used to updates in existing data or to
maintain history Data along with existing one
Is This Answer Correct ? | 1 Yes | 0 No |
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
Can i create a lookup table without cache.
Explain direct and indirect flat file loading (source file type) - informatica
what is metadata?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
draw informatica architecture 8.6 ?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
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 .
how we can update a target table without update strategy and update override?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
how do u move the code from development to production?