Answer / kalpana

costbased and rule based approaches r used as optimization
techniques in improving the performance of queries

What is metadata reporter?

1 Answers   Informatica,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

what is normalizer transformation?

4 Answers   Wipro,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---

what is data driven?

5 Answers   TCS, Wipro,

---

What are the new features of informatica 9.x developer?

0 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---