Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8739 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
Repository user profiles
What is target load order?
Explain your project of banking domian.
What is a difference between complete, stop and abort?
Name the different lookup cache(s)?
What is depict expression change?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain what are the different versions of informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Design time, run time. If you don't create parameter what will happen
What is an active transformation?
Did u used latest transformations of 8.6.0? for what?
How can one identify whether mapping is correct or not without connecting session?
What is a grid in Informatica?
