Answer Posted / babu

Hi Sbvprasad,
Your answer has small correction,

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.Take an EXP t/r,in this t/r declare two variable ports
for ID and Name columns.those are PRV_ID and VAR_NAME

VAR_NAME=IIF(PRV_ID=ID,VAR_NAME||' '||NAME,NAME)
PRV_ID=ID
OP_NAME=VAR_NAME (OUTPUT PORT)

3.In the next step take the aggregator transformation and
group by on the ID COLUMN. Then you will get the result.

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

MAPPING ::
---------

SRC-->SQ-->EXP-->EXP-->AGGR-->TRG
IF ANY THING WRONG, PLEASE CORRECT WITH PROPER SOLUTION.

What are the mapping parameters and mapping variables?

1087

---

EXL informatica Questions

1310

---

how many types of dimensions are available in informatica?

997

---

Explain sql transformation in script mode examples in informatica

1046

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2063

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047

---

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

1085

---

Enlist few areas or real-time situations where informatica is required.

1020

---

Explain sessions and how many types of sessions are there?

955

---

What is a joiner transformation?

938

---

How to load the data from people soft hrm to people soft erm using informatica?

949

---

What is a passive transformation?

1037

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1017

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1079

---

How can you validate all mappings in the repository simultaneously?

1287

---