What are the different types of Type2 dimension maping?
- 1 Answers
- 4954 Views
- I also Faced
- E-Mail Answers
Answer / swetha
source will gets inserted in target along with a new
version number. And newly added dimension in source will
inserted into target with a primary key.
Type2 Dimension/Flag current Maping: This maping is also
used for slowly changing dimensions.In addition it creates a
flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent
dimensions will gets saved with cuurent flag value 1. And
updated dimensions r saved with the value 0.
Type2 Dimension/Effective Date Range Maping: This is also
one flavour of Type2 maping used for slowly changing
dimensions. This maping also inserts both new and changed
dimensions in to the target. And changes r tracked by the
effective date range for each version of each dimension.
| Is This Answer Correct ? | 2 Yes | 0 No |
Two different admin users created for repository are ______ and_______
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What are data-driven sessions?
What is the difference between a repository server and a powerhouse?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
What if the source is a flat-file?
Which is costliest transformation? costly means occupying more memory?
What is a pre-defined event and user-defined event?
Can we use parameters of parameter file in presession command
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
What is the Difference between PowerPlay transformer and power play reports?
Teradata 
