Answer Posted / rajesh

select * from emp natural join dept;

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

653

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1075

---

can anyone explain me about retail domain project in informatica?

7429

---

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

1004

---

What is fact table? Explain the different kinds of facts.

610

---

---

What are the new features of informatica 9.x at the developer level?

600

---

Why update strategy and union transformations are active?

589

---

what is the hint? how to use it to reduce the query processing in program?

6287

---

What are the different types of transformation available in informatica.

632

---

Design time, run time. If you don't create parameter what will happen

1422

---

How do you take back up of repository?

717

---

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?

1042

---

What is olap (on-line analytical processing?

637

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1630

---

Can you generate sequence numbers without using the sequence generator transformation?

595

---