Answer / sivaprasad

Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3

If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored

Answer / chluff12

to decide to insert, update, delete or reject the data.

What is the Rankindex in Ranktransformation?

7 Answers  

---

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---

Define update strategy?

0 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

What is factless fact schema?

1 Answers  

---

What are conformed dimensions?

1 Answers  

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---