Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 9096 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Difference between Target-based loading and constraint-based loading?
is it possible to index the data in cache of lkp transformation ?
Separate from a database, an information bazaar, and an information stockroom?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to improve the performance of a session using sorter transformation?
What is the use of code page?
In informatics server which files are created during the session rums?
Where do we use mapping variables in informatica?
Explain what is informatica metadata and where is it stored?
differences between service based and product based?
