In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?
Answer Posted / talluru.sankar naidu
we can use SQ transformation write the query we get ans
select sun(sal) from emp where deptno=10 and deptno=5;
I think its correct
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Define mapping and session?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain lookup transformation in informatica
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?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
wat are deployement groups in informatica, how it will be used for developers
Briefly describe lookup transformation?
What is a filter transformation?
What are the limitations of joiner transformation?
What is the Rank index port in Rank transformation?
What is data caches/ index caches?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is olap (on-line analytical processing?
How to handle decimal places while importing a flatfile into informatica?