Answer Posted / chemistrya2z

select * from <tbl> where rownum<2;

What is a sorter transformation?

660

---

Difference between Target-based loading and constraint-based loading?

553

---

As union transformation gives UNION ALL output, how you will get the UNION output?

646

---

What is InformaticaPowerCenter?

692

---

How many ways are there to do 'remove duplicate records in informatica'?

585

---

---

What is an expression transformation in informatica?

519

---

How many numbers of sessions can one group in batches?

623

---

What is repository manager?

538

---

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

1012

---

What do mean by local and global repository?

705

---

What is source qualifier transformation in informatica?

575

---

What is parallel processing in informatica?

1031

---

In which transformation you cannot drag ports into it?

780

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1054

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

633

---