avneeshrathor

 Profile Answers by avneeshrathor Questions by avneeshrathor

• Nov 3rd, 2009

For some special cases like for example, You need to select the max salary
from emp table for a particular dept. then use
"select max(salary) from emp where deptno=in_dept_no
group by deptno".

Kindly let me know if this is possible without using SQL override in lookup.

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..

Answer Question  Select Best Answer

What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on windows environment, but will be shifted to UNIX environment. Please describe in details starting from installation of informatica in UNIX to run or guide the working on informatica in Unix environment.

Amit Tarafder

• Feb 16th, 2017

Informatica is installed on Unix servers. Unix is used to run different shell scripts in server environment through
Informatica command tasks.

sriluck

• Sep 24th, 2007

HiThese are some ways unix works with Informatica.1) In unix box, we can create a SCRIPT which calls informatica session  and make the session run.2) We can UPDATE STATISTICS or CLEANUP files by ...

Answer Question  Select Best Answer