In Which scenario did u used Incremental loading?
Answers were Sorted based on User's Feedback
Whenever your record changes and any date column get
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramu
for capturing the changed data in source we use the
incremental loading.
Is This Answer Correct ? | 0 Yes | 0 No |
what is the use of Data Mart?
How can you validate all mappings in the repository simultaneously?
Explain about perform recovery?
what is dimension table?
What is degenerated dimention table?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
How to load duplicate records in to a target table which has a primary key?
what is confirmed dimension?
8.what is mapplet ?give example?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How