Answer / guest

data driven is the instruction fed to informatica server
wheather to insert/update/delete row whenever using update
strategy transformation

Answer / ziauddin

When u configure a session using update strategy the
session property data driven instructs informatica server
to use the instructions coded in mapping to flag the rows
for insert, update, delete, this is the default option
selected when using a update strategy transformation in a
mapping.

Answer / kamesh

When ever a mapping contains Update Strategy Transformation
the way data needs to be treated is declared in the session
property as Data Driven. This is done by mentioning
DD_UPDATE or DD_INSERT or DD_DELETE in the update strategy
transformation.
A mapping may contain two Update strategy transformations,
1 for inserting and another for updating in two different
pipelines in single mapping.

Therefore, in order session to get executed successfully,
mention Data Driven property in the session properties for
that particular mapping.

Answer / yaseen

Data driven is a process, in which data is
insert/deleted/updated based on the data. here it is not
predifed tht data is to insert or delete or update .. it
will come to knw only when data is proceesed

Answer / maheshg

The informatica server follows instructions coded into
update Strategy transformations with in the session maping
determine how to flag records for insert,update,,delete or
reject If u do not choose data driven option setting,the
informatica server ignores all update strategy
transformations in the mapping

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

List the transformation in informatica.

1 Answers   TCS,

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

tell me about your project functionality

0 Answers  

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

What are the different types of repositories created using informatica?

0 Answers  

Explain lookup transformation in informatica

0 Answers   Informatica,

What is the use of transformation?

0 Answers  

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers