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

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

Explain the pipeline partition with real time example?

0 Answers   Informatica,

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  




without table how to come first record only in oracle?

0 Answers  

Without using any transformations how u can load the data into target?

15 Answers   IBM,

How to add source flat file header into target file?

3 Answers   Logica CMG,

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

What is the use of target designer?

0 Answers  

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

How to update records in Target, without using Update Strategy?

3 Answers  

For more Informatica Interview Questions Click Here
Categories