Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 2 Answers
- 10274 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 |
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
How Union Transformation is an Active Trans?
how the informatica server sorts the strings values in rank transformations?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is runtime variable?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
permutations of mapplet
what is distinct
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
What are the designer tools for creating transformations?
where actually the usage of push down optimization happens...
Teradata 
