Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 2 Answers
- 10452 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumankumar
type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / chaitanya
Using SCD2 mapping Target warehouse can store recent data+ complete historical data
Type2 dimension mapping or SCD2 mapping can be implemented in 4 ways: i)Limited number of Histories
ii)Star Schema support implementation
iii)Unlimited number of Histories
iv)Unconnected Stored Procedure
| Is This Answer Correct ? | 0 Yes | 0 No |
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What are the new features of Power Center 5.0?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
what is the incremental agrrigation?
How we can use union transformation?
In informatica workflow manager, how many repositories can be created?
What are the main features of Oracle 8i with context to datawarehouse?
Explain in detail about scd type 1 through mapping.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Why we use ENABLE HIGH PRECISION in session properties?
how to create a sample mapping for dynamic lookup transformation
Teradata 
