Answer / preeti

Incremental load is adding/inserting only changed/latest
data from the source.In incremental loading,history data
could remain as it is along with the new data or
overwritten by incremental data.

Answer / bsgsr

capturing the chnged data from the source using the concept
of mapping variable for timestamping is known as
incremental loading.

the other load type is full load where we go for full
refresh.

Answer / rajendra

Incremental loading is load the

History data
Present data

and add insert new data to the table

Answer / vijay

increamental loading is the concept of capturing the new
records and updated records from the source it is very help
full in scd's - 2

Answer / chandramohan reddy

it is a process of considering only new records by omitting
existing records for data load is known as incremen loading.

Answer / sekhar

Incremental load is adding/loading only changed/latest updated
data from the source.In incremental loading,history data
could remain as it is along with the new data or
overwritten by incremental data and also the other load type is full load where we go for full refresh.

Answer / apps

Incremental loading is nothing but the cdc(change data
capture)
used to capture the data like insert,update and deleted
data on a table.
1)for this we need exec the sp against the db is to enable
the cdc.(select is_cdc_enabled where db_name='cdc_test')
2)Enable the cdc against the table in the db.(exec
sys.sp_cdc_enable_table @source_schema=-----,@source_name=-)
3)wheather the db/table enabled for the cdc by writing a
select query aginst db/table.If it returns 1 enabled or it
returns 0 not enabled.
(select is_tracked_by_cdc from sys.tables where tab_name='--
--')



any suggetions revert me via ravipati65@gmail.com

apps

Answer / gopinath

In Incremental loading the differnce between the source and
target are dumped at regular intervals. Here we give the
last extract date so that changes only of this particular
date will be loaded to the target tables.

Answer / kesava

Incremental aggregation is defined as the integration service performs aggregate calculations & stores the data in history cache & it reads only new data when it loads the new data ...

Answer / razeen

Last__Extract_Date = The date Fro which you need the data(to
get latest records)

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

what is song in infrmatica...?

0 Answers   CTS,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

how i will stop my workflow after 10 errors

2 Answers   HP,

Is informatica power center designer has 64 bit support?

1 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

How i can upload the MainFrame source For Informatica ?

1 Answers  

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers