Answer Posted / psnadh

Informatica 7.1:
Doesnot supports service oriented architecture & Universal
data access
Dynamic Partitioning & Push Down optimization is not
available
We cann't define our own userdefined functions

where as Informatica 8.1 supports all the above features

waht type of interface is used for testing the data in informatica

2190

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1967

---

What are the restrictions of union transformation?

976

---

What is dimensional table? Explain the different dimensions.

1108

---

What is source qualifier transformation in informatica?

941

---

What is data caches/ index caches?

1017

---

What is a dimensional model?

926

---

To import the flat file definition into the designer where should the flat file be placed?

1004

---

What the difference is between a database, a data warehouse and a data mart?

1079

---

How to generate sequence numbers without using the sequence generator transformation?

1110

---

Can we create two repositories on same database instance in oracle?

1011

---

What are Dimensional table?

996

---

What is meant by a domain?

1077

---

How to configure mapping in informatica?

1116

---

Make a note of the quantity vaults made in informatica?

938

---