What are the different types of Type2 dimension maping?
- 2 Answers
- 9328 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 |
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
how do u use sequence created in oracle in informatica? Explain with an simple example
wht is full process of Information source to target just like stg to productuon and development
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Write the program through which the records can be updated?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
What is decode in static cache?
What are the designer tools for creating transformations?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Teradata 
