Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10443 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / rampriya
I think, we can use the source qualifier (active
transformation)- query override
select sum(sal) from emp where dept=10
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is domain in terms of informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Where can we find the throughput option in informatica?
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 rank transform?
How do you convert single row from source into three rows into target?
How to extract sap data using informatica?
What is a stored procedure transformation?
What is the difference between a connected look up and unconnected lookup?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are pre and post-session shell commands?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the informatica performance improvement tips
Design a mapping to load a target table with the following values from the above source?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
