Answer Posted / suresh

cant we write a subquery?

delete from table emp where exists (select * from emp where rownum=1 or 2 or 3);

count(empno) --> has to be stored in a variable port and delete the last three rows of the target table.

Define Pmrep command?

632

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1866

---

What is an active transformation?

644

---

Explain the types of lookup transformation?

568

---

Write the different tools in the workflow manager?

570

---

---

How to improve the performance of a session using sorter transformation?

686

---

How do you load alternate records into different tables through mapping flow?

1288

---

Can informatica load heterogeneous targets from heterogeneous sources?

694

---

Explian the Process of deployment groups in informatica

656

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

769

---

What are the types of schemas we have in data warehouse.

528

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1050

---

How do you change a non-reusable transformation to reusable transformation?

593

---

what is the size of your data warehousing?

1669

---

What are the various types of transformation?

640

---