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

To import the flat file definition into the designer where should the flat file be placed?

1059

---

Define joiner transformation?

1047

---

What is difference between a gateway node and worker node?

1136

---

What is informatica powercenter repository?

1200

---

In warehouses how many schemas are there?

1070

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9817

---

What is the difference between a repository server and a powerhouse?

1507

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2177

---

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

1054

---

How do you migrate data from one environment to another?

1095

---

Is stop and abort are same in informatica?

999

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2324

---

what is mean by complex business rule ?

2158

---

What are the main issues while working with flat files as source and as targets ?

1153

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1263

---