Answer Posted / muddam

Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.

What is the difference between a connected look up and unconnected lookup?

969

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2200

---

How to configure mapping in informatica?

1174

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2186

---

Global and Local shortcuts. Advantages.

2035

---

What do mean by local and global repository?

1227

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2171

---

What is joiner transformation in informatica?

1046

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1915

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2039

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2031

---

Explain in detail scd type 2 through mapping.

1046

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2050

---

Slowly changing dimensions, types and where will you use them

1717

---

Different circumstance which drives informatica server to expel records?

985

---