Answer Posted / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

Briefly describe lookup transformation?

994

---

What are the types of schemas we have in data warehouse and what are the difference between them?

908

---

can we override a native sql query within informatica? How do we do it?

1076

---

How does a rank transform differ from aggregator transform functions max and min?

1165

---

What are the measure objects?

1138

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1037

---

whats the logic to load the lower level of granularity of data to fact table.

2225

---

Mention few advantages of router transformation over filter transformation.

994

---

Please let me know how to make Data masking in informatica..

1679

---

What is the advantage of informatica?

1025

---

What is joiner change?

1093

---

What are the reusable transformations?

1115

---

What is the format of informatica objects in a repository?

984

---

Explain sessions. Explain how batches are used to combine executions?

966

---

How to create Target definition for flat files?

1179

---