Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 / chinthi

Answers were Sorted based on User's Feedback



source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa ..

Answer / 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

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa ..

Answer / kulasekhar reddy tholeti

Try it 100% you will get answer.

Select name,no from source
union
select "total",sum(sal) from source;

Is This Answer Correct ?    1 Yes 0 No

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa ..

Answer / chinthi

actually i need total as new record value as 10000

Is This Answer Correct ?    0 Yes 0 No

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa ..

Answer / babu

Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.


Please check and intimate in case of any issues.

dwarak.vbr@gmail.com

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

how to we create datamart?

2 Answers   HSBC,

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

Tell me about Propagate functions in informatica

0 Answers  

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

How can we update a record in the target table without using update strategy?

0 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

Explain the features of connected and unconnected lookup.

0 Answers  

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

What is the benefit of session partitioning?

0 Answers  

Explain the different dimensions.

0 Answers  

For more Informatica Interview Questions Click Here
Categories