Interested to Buy Any Domain ? << Click Here >> for more details...
wat transf shud i use to achieve this
id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35
- 2 Answers
- 5597 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uma
Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rk
Use analytical function if source is database..
SELECT ID, SAL, SUM(SAL) OVER (PARTITION BY ID) AS SUM from table.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
how to remove staging area
how lookup is acting as both active and passive ? how is it possitble?
Two different admin users created for repository are ______ and_______
What is an MDDB? What is the difference between MDDBs and RDBMSs?
what is song in infrmatica...?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
What are the reusable transformations?
Differnce between filter and router?
Teradata 
