Answer Posted / 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

Explain what transformation and how many are there in informatica?

1021

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1058

---

What are the reusable transformations?

1216

---

Tell me about MD5 functions in informatica

979

---

Differentiate between joiner and lookup transformation?

1157

---

Explain sessions?

1136

---

Which transformation is needed while using the Cobol sources as source definitions?

1218

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1194

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1152

---

Explain pmcmd command usage in informatica

1184

---

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

2249

---

Differentiate between router and filter transformation?

1063

---

What is meant by target load plan?

1026

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1137

---

How to convert multiple rows to single row (multiple columns) in informatica

1425

---