select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
Answer Posted / cmanojkumar
Hi,
Thanks for your answer.
If we take this in single pipeline it will not allow us to
connect aggregator transformation and source qualifier
transformation to target transformation
Because we can't combine two active transformations to
another transformation.
I would like to know these rules. Can any on tell me why
can't we combine active and active ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What is informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a filter transformation and why it is an active one?
What is sq transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to create the source and target database connections in server manager?
How can you define user defied event?
Is it possible to use a client with different version than that of its Informatica server?
How do you handle two sessions in Informatica
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.
Design time, run time. If you don't create parameter what will happen
How big was your fact table
What are the modules in Power Center