Design a mapping to calculate department wise sum of salaries and load it in single target?
Source Target
Deptno Salary Deptno Salary
10 100 10 600
10 200 10 600
10 300 10 600
20 200 20 800
20 300 20 800
20 300 20 800
30 400 20 1500
30 500 30 1500
30 600 30 1500
No Answer is Posted For this Question
Be the First to Post Answer
Define sessions in informatica etl?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What is a predefined event?
how can u approach u r client
While importing the relational source defintion from database,what are the meta data of source U import?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
What if the source is a flat-file?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
How to call shell scripts from informatica?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
what is plsql table?
What is rank index in rank transformation?