Answer / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

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?

0 Answers  

---

How can we use mapping variables in informatica?

0 Answers  

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

What are the databases that informatica can connect to windows?

0 Answers  

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

What is primary and backup node?

0 Answers  

---