select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8025 Views
- Puma, I also Faced
- E-Mail Answers
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
Explain the etl program with few examples.
Briefly define reusable transformation?
What is the need of etl tools?
What is the benefit of partitioning a session?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How does a sorter cache works?
What is meant by pre and post session shell command?
How to handle decimal places while importing a flatfile into informatica?
Briefly define a session task?
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
can you please explain me pre session and post session options?
tell me 5 session failure in real time how can you solve that in your project?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is informatica etl tool?
