select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
Answer Posted / rudra
SQualifier --> Sql Query -->select * from emp where sal>(select min(sal) from emp) -->Apply-->OK -->connect to TGT table (save it)
## Create wf and ssn then run it
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of code page?
What is confirmed fact in dataware housing?
What are the designer tools for creating transformations?
What is InformaticaPowerCenter?
What are active and passive transformations?
Is it possible to use a client with different version than that of its Informatica server?
In which transformation you cannot drag ports into it?
As union transformation gives UNION ALL output, how you will get the UNION output?
How do you convert single row from source into three rows into target?
Explain constraint based loading in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
What does cheating measurement mean?
How an expression transformation differs from aggregator transformation?
What are the different transaction levels available in transaction control transformation?
What is an Integration service in Informatica?