Answer / nitin

1) we can not perform PDO if we are using variable ports and informatica inbuilt functions.
2) If we have source and target on the different schema we can not go for full PDO, in this case either we have to go for source PDO or Target PDO.

Answer / rao

1)We can not apply push down optimization if mapping contain
aggregate transofrmation.

2)When we implement p.optimization ,the integration services
send logic to databases.because of this wa can not capture the
rejected records in reject file.

Answer / chandu

we can't implement for aggregator tranformation
we cant implement for master source in joiner transformation

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

what is Active lock explain

0 Answers   Satyam,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

What are the databases that informatica can connect to windows?

0 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---