Answer / raj

sourcequalifier....>normalizer.....>expression...>aggrgater....>target

Answer / usha

by using normalizer transformation we can convert rows to
columns.

s-->SQ--->NRM-->Target

Answer / dev

hi Raj, plz explain, what we need to do in expression
transformation...

Answer / kamleshmishra291

SQ->EXP->NRM->TGT

EXP :-- CREATE 4 OUTPUT PORTS
PORT1= 'JAN'
PORT2='FEB'
PORT3='MAR'
PORT4='APRIL'
AGGR :-- DRAG ALL PORTS FROM EXP AND CREATE 4 OUTPUT PORT
PORT5= SUM(JAN)
PORT6=SUM(FEB)
PORT7=SUM(MAR)
PORT8=SUM(APRIL)
NRM : CREATE 2 PORTS
MONTHS- OCCUR(4)- STRING
TOTAL- OCCUR(4)- NUMBER
CONNECT NRM OUTPUT PORT TO TGT

Answer / shankar

source qualifier > expression <for best practice> > aggregator > normalizer . target.

here in this the SQ will be for relational & flat files, then we use expression for best practice, in this we take the ports which we need into target also we can rename the ports for our convenience just to avoid confusion.

Then for calculating totals we use aggregator.

to convert the rows to col we use the normalizer. This is to my knowledge. Thank you if wrong pls post.

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

Could any one to tell Fact table Partitioning?

2 Answers  

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

What is a rank transform?

0 Answers  

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

permutations of mapplet

0 Answers   TCS,

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,