Interested to Buy Any Domain ? << Click Here >> for more details...
scd methodology?
- 2 Answers
- 6172 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rr
SCD means slowly changing dimension.
It represents dimensions that change with time.
There are three types of scds.
Type1: Overwrite (contains no history)
Type2: Add an additional record with time stamp or flag
(contains history)
Type3: Add a new field for the record to represent the new
value(contains history)
| Is This Answer Correct ? | 1 Yes | 0 No |
Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.
Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.
Version:The changes made will be numbered as 0,1,2...so on.
Date:The changes along with the date in which they are made
are clearly mentioned.
Type3:The latest change which is made is alone available.
| Is This Answer Correct ? | 0 Yes | 0 No |
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
What is informatica metadata and where is it stored?
How do you use reject loader.
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
How to join three sources using joiner?
h0w many versions have been developed of onformatica so far?
What is Collect performance data in informatica and what is the use of it.
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How do you load only null records into target? Explain through mapping flow.
What are roles and groups and benefits of using them?
Teradata 
