Answer / swetha

Within a session. When you configure a session, you can
instruct the Informatica Server to either treat all records
in the same way (for example, treat all records as inserts),
or use instructions coded into the session mapping to flag
records for different database operations.

Within a mapping. Within a mapping, you use the Update
Strategy transformation to flag records

Why filter transformation is an active one?

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

explain about session partitions ?

1 Answers  

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

What is degenerated dimention table?

7 Answers   Patni,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---