Answer / jagadish

update strategy transformation is used to perform DML
operations for the already data populated targets.

by default informatica server will treat source row as
INSERT.if you use update strategy transformation in your
mapping the informatica server will treat source row as
DATA DRIVEN.so the datas transferd to a target that even
populated with some data can be inserted,updated,rejected
and deleted.based upon the functions like
dd_insert,dd_update,dd_reject,dd_delete you define in the
update strategy transformation.

Answer / geetha

Updatestartegy used to define Transaction control
Informatica default transaction Insert
Using updatestartegy we can define
(1) Dd_insert
(2) Dd_update
(3) Dd_delete
(4) Dd_reject

Answer / soujanya

used to perform dml operations such as insert update delete

Answer / swetha

This transformation is used to maintain the history data or
just most recent changes in to target table.

Answer / obulreddy.b

IT IS A TRANSFORMATION WHICH IS USED TO PERFORM DML
OPERATIONS ON ALREADY DATA POPULATED TARGETS.


GENERALLY INFORMATICA SERVER WILL TREAT SOURCE ROWS AS
INSERT. IF WE USE UPDATE STRATOGY TRANSFORMATION WE HAVE TO
SELECT TREAT SOURCE ROWS AS DATADRIVEN IN SESSION
PROPERTIES, NOW INFORMATICA SERVER DRIVES THE DATA AS PER
UPDATE STRATOGY VALUE.

WE HAVE TO SELECT UPDATE STRATOGY VALUE BASED ON OUR
REQUIREMENT.

Answer / usha

This Transformation is used to perform DML operation for
the already data populated target.

Answer / saribalareddy

Whenever you create the target table whether you are store the historical data or current transaction data in to target table.

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 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  

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

What are the different threads in DTM process?

1 Answers  

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

what is informatica metadata?

0 Answers  

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

How to load a relational source into file taget?

2 Answers  

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,