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 your project of banking domian.

1652

---

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

2122

---

What is a sorter transformation?

1102

---

what is the Default Source Option For Update Strategy Transformation?

1241

---

Differentiate between sessions and batches?

1018

---

What is meant by query override?

1061

---

What is an unconnected transformation?

1087

---

If informatica has its scheduler why using third party scheduler?

1268

---

 Informatica Checkpoints

3332

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

What is domain in terms of informatica?

1007

---

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

1086

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2123

---

Why update strategy and union transformations are active?

1042

---

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

---