In Which scenario did u used Incremental loading?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2430


What is a router transformation?

634


What are the main features of Oracle 8i with context to datawarehouse?

1684


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1539


Design time, run time. If you don't create parameter what will happen

1428






What do you mean by enterprise data warehousing?

652


write a query to retrieve the latest records from the table sorted by version(scd)

637


Different circumstance which drives informatica server to expel records?

556


expain about the tune parameters?

1890


How do you load alternate records into different tables through mapping flow?

1298


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6422


What is union transformation?

577


What is the benefit of partitioning a session?

635


Can you use flat files in Mapplets.

2226


How to extract sap data using informatica?

607