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)

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

What are the out put files that the informatica server creates during the session running?

2 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

In warehouses how many schemas are there?

0 Answers  

what is flat file override?

1 Answers   Cap Gemini, HP,

what is the location of parameter file in informatica?

1 Answers   TCS,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

what type of transformation is not supported by mapplets?

4 Answers   CTS,