What are the different types of Type2 dimension maping?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the different dimensions.
Describe expression transformation?
Explain how many types of dimensions are available in informatica?
What are the differences between source qualifier and joiner transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can we create multiple integration service on single repository?
Enlist the advantages of informatica.
Explain sql transformation in script mode examples in informatica
what is $$$$?
What is the need of an ETL tool?
What is joiner transformation in informatica?
What do you mean by enterprise data warehousing?
What do you mean by channel change?
What are the main issues while working with flat files as source and as targets ?
Plz can any one say me how to get the informatica certification materials and dumps