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

How to implement security measures using repository manager?

1102

---

What do think which one is the better joiner or look up?

1162

---

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

1057

---

How do you change a non-reusable transformation to reusable transformation?

959

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1899

---

Under which circumstances, informatica server creates reject files?

1037

---

How can repository reports be accessed without sql or other transformations?

1171

---

What is parallel processing in informatica?

1639

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1986

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1043

---

What is the need for an etl tool?

1025

---

What is fact table? Explain the different kinds of facts.

1026

---

What is depict expression change?

1048

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1599

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1042

---