1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

source
name sal
aaaa 2000
bbbb 3000
abcd 5000


Target
name sal
aaaa 2000
bbbb 3000
abcd 5000
total 10000


how to get total as new row and sum as 10000

thanks

Question Posted / babu

Answer Posted / babu

Hi,
Mapping:

SRC==>EXP==>AGGR==>UNION
|==>TRG
SRC==>

EXP:In first DFD we have EXPR and AGGr,in EXPR we have to
take one output port with a constant value by using that
output port calculate the sum sal in AGGR.In AGGR take one
output port that as name field with constant value(total)
and the sum sal field as sal after that UNION trns is there
union the two DFD's,finally we get the what we expect.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a surrogate key?

669

What is data caches/ index caches?

697

What is meant by lookup transformation?

698

What is a router transformation?

727

How union transformation is used?

671




What is dynamic cache?

695

What is meant by LDAP users?

776

Explain what are the different types of transformation available in informatica.

664

What is InformaticaPowerCenter?

786

Explain what is informatica metadata and where is it stored?

690

How can you define user defied event?

717

Why do we need informatica?

643

What is expression transformation?

721

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. ?

1691

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1956