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

Explain sessions and how many types of sessions are there?

0 Answers  

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

How do you change parameter when you move it from development to production.

1 Answers  

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

What is a data modeling?

2 Answers  

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

how can import the data from the flat files?

2 Answers  

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

For more Informatica Interview Questions Click Here
Categories