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
- 10395 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
How an expression transformation differs from aggregator transformation?
What are the different options available for update strategy?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a joiner transformation and why it is an active one?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the settings that you use to configure the joiner transformation?
can u any challenge your project?
What is a joiner transformation?
Have you worked with/created Parameter file
What are session parameters ? How do you set them?
Performance tuning in UNIX for informatica mappings?
What are roles and groups and benefits of using them?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the etl program with few examples.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
