Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7894 Views
- Polaris, I also Faced
- E-Mail Answers
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
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you handle two sessions in Informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the meaning of up gradation of repository?
what is SDLC way of code development?
What all join we can perform in LOOKUP transformation?
How to delete duplicate row using informatica?
Explain the features of connected and unconnected lookup.
How many ways are there to create ports?
What are the various types of transformation?
What is difference between a gateway node and worker node?
What is a transaction control transformation?
What are the types of lookup transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pushdown optimization $pushdownconfig parameter - informatica
