Answer Posted / sbvprasad

V1=iif(not isnull (id),id,v1)

for the 1st record.
V1= iif( not isnull (101), then pass 101).
now the V1 variable having the value = 101.

2nd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

3rd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

After applied the above logic we will get the output as
mentioned below.
-------------
ID NAME
--- ------
101 PANKAJ
101 KUMAR
101 MATHUR
102 JYOTI
102 SAXENA
103 SACHIN
102 TENDULKAR

2.In the next step take the aggregator transformation and
group by on the id. Then you will get the result.

TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR

What is a predefined event?

1097

---

How might one distinguish in the case of mapping is right or not without associating session?

1131

---

What are the mapping parameters and mapping variables?

1210

---

Please let me know how to make encryption and decryption with example?

1908

---

What are the main features of Oracle 8i with context to datawarehouse?

2115

---

What is a pre-defined event and user-defined event?

1043

---

What are junk dimensions?

1076

---

Explain what are the different versions of informatica?

1102

---

What are the data movement modes in informatica?

1166

---

What is a dimensional model?

987

---

Explain scd type 3 through mapping.

1023

---

What do you mean by blocking transformation?

1052

---

How do you load unique records into one target table and duplicate records into a different target table?

1268

---

What is transformation?

1106

---

Define mapplet?

1018

---