Answer Posted / venkat

Hi Mukesh,

This is venkat can you please send informatica
certification to my mail id is prasad.reddy3449@gmail.com

Thanks in Advance
venkat

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1588

---

update strategy transformation in informatica

1072

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2383

---

What is data caches/ index caches?

1110

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1130

---

What is a filter transformation?

1050

---

explain abt ur project architecture?

2200

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1094

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1046

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6194

---

Define pmcmd command?

1049

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1966

---

What is a joiner transformation and why it is an active one?

1087

---

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

2013

---

What is sequence generator transformation in informatica?

1084

---