Answer Posted / raka

SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;

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

1046

---

What is a passive transformation?

1054

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

994

---

How can we improve session performance in aggregator transformation?

1060

---

What is Data Caches size?

1053

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2203

---

what is the difference between informatica6.1 and infomatica7.1

2213

---

What is the difference between informatics 7x and 8x and what is latest version?

1045

---

How many ways are there to create ports?

1268

---

How do you set a varible in incremental aggregation

1839

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2164

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3664

---

What are connected or unconnected transformations?

1069

---

What are the different types of olap? Give an example?

999

---

What is workflow? What are the components of the workflow manager?

1088

---