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
- 5607 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 |
can we create index and drop index in exsisting table while using infomatica
how to delete duplicate records by using filter transfermation?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Why the workflow is failed after running two hours in informatica?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
What is aggregate awareness?
What are the differences between joiner transformation and source qualifier transformation?
How will you combine 3 different sources with a single source?
How to create a non-reusable instance of reusable transformations?
In dimension and fact table? which one holds big data?
How many ways are there to create ports?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
Teradata 
