Answer / sandeep

(Q) If I have set the property Treat Source Rows as Insert
and for the target properties I have checked the boxes
Update as Update, what will happen to incoming rows?

Answer:
- When you set propery Treat source rows as Insert and also
checked Insert in target properties then IS will treat all
source rows as inserts.
- If you miss to check insert option in target properties,
all the source records will be rejected.
- If at all you also set properties like update and delete
along with insert in target properties, it will ignore
update & delete options and treat source rows as inserts.

Answer / sukanta

If I have set the property Treat Source Rows as Insert and
for the target properties I have checked the boxes Update as
Update, what will happen to incoming rows?
Ans-
All records will be reject if you not enable insert
option.Additionally what option you choose no matter.

What exactly is the use of these check boxes and in which
scenarios we use them. Also what is the sequence in which
informatica understands these properties.Does it takes
whatever is defined in treat source rows as property or it
is in any other way. Please explain.

By default the treat source row is always Insert option.If
you use a update strategy transformation in mapping it will
converted to Data Driven,it means what operation will
happen(insert,update &delete) will be finalized in update
strategy.Update strategy has 4
parameter(dd_insert,dd_update,dd_delete & dd_reject).As per
your parameter logic the record will tagged for target
operation.As example Insert tag for a record means it will
insert in the target table if target insert option is
enabled.Otherwise the records will be rejected.Likely for
delete and reject.But for update tag in target there are 3
options update as update,update as insert and update else
insert.if you choose any of last two it will insert the the
record in target if simultaneously insert option is enabled.

There is no order of operation only based open the options
you choose.

Think it clear all.

Regards
Sukanta

Answer / sumit

Session Will Fail. Unable to Insert into the Target table error.

Please correct me if i am wron

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

What is meant by target load plan?

0 Answers  

---

What is joiner transformation in informatica?

0 Answers  

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

Have you worked with/created Parameter file

0 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---