Answer Posted / babu

Hi Aruna,

U r answer has small change,i.e one output port and in
aggregator t/r column1 is group by port not column2.

SRC
|
SQ
|
EXP
{
(variable port) var:IIF(col1=var1,concat(var,col2),col2)
(variable port) var1:(col1)
(output port) oup:var
}
|
AGGR(COL1 AS A GROUP BY PORT)
|
TRG

MAPPING DESIGN::

SRC-->SQ-->EXP-->AGGR-->TRG

Explain the difference between mapping parameter and mapping variable?

1033

---

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

2109

---

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

939

---

What are the guidelines to be followed while using union transformation?

1135

---

Define update strategy?

1214

---

Which are the different editions of informatica powercenter that are available?

1032

---

What are the different types of repositories created using informatica?

1124

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

---

Write the prerequisite tasks to achieve the session partition?

1149

---

How many ways are there to do 'remove duplicate records in informatica'?

1007

---

What is deployment group?

1206

---

What is joiner transformation in informatica?

1043

---

What is aggregate cache in aggregator transformation?

1139

---

Partition, what happens if the specified key range is shorter and longer

2489

---

What are the components of Informatica? And what is the purpose of each?

1053

---