In Which scenario did u used Incremental loading?

Answers were Sorted based on User's Feedback



In Which scenario did u used Incremental loading?..

Answer / dharmendra singh

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

In Which scenario did u used Incremental loading?..

Answer / ramu

for capturing the changed data in source we use the
incremental loading.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the use of Data Mart?

5 Answers   IBM,


How can you validate all mappings in the repository simultaneously?

0 Answers  


Explain about perform recovery?

1 Answers  


what is dimension table?

17 Answers  


What is degenerated dimention table?

7 Answers   Patni,






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

3 Answers   Infotech,


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


How to load duplicate records in to a target table which has a primary key?

2 Answers  


what is confirmed dimension?

6 Answers  


8.what is mapplet ?give example?

2 Answers  


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

4 Answers   TCS, Wipro,


Categories