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
- 5511 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 |
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Informatica and datawarehousing courses in Pune?
What are the different ways to implement parallel processing in informatica?
How/where can i install Informatica software with oracle or teradata as database
what is junk dimension
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Explian the connected and unconnected lookup transformation
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Is informatica power center designer has 64 bit support?
disable caching in a lookup transformation?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
Teradata 
