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
What is the Process to creating lookup transformation in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain in detail scd type 2 through mapping.
Where can we find the throughput option in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is sorter transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How can informatica be used for an organization?
How to load a Dimension ? and how to load a fact table?
Can we create a Integration service without a Repository service and vice versa?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is informatica etl tool?