Answer / moorthy g

In Source Qualifier Sql Override
Ex: Table Name: Dept1
SELECT DEPT1.DEPTNO, DEPT1.DNAME, DEPT1.LOC
FROM
DEPT1
WHERE ROWNUM=1

Answer / abhishek kumar

step 1
if first row h as not null then we can use first()
function in aggregator T/F.

step 2
use sequence generator T/F And filter T/F write condition
nextval=1

Answer / gandra krishna reddy

by using first function in aggregator transformation.

Answer / moorthy g

SQ-Sorter-Seq-Exp-Fiter(nextval=1)-Target

Answer / basi

your question is worng . because you are asking fist row
why are you using rank t/r

Answer / balakrishna

select empno,name,deptno,loc from emp where rownum=1
                       and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target                       
                      and
source--->sq--->seq--->exp--->filter--->target
                      and
select * from emp where rownum=1minusselect * from emp where rownum=2

Answer / venkatgiri

select * from Table_name limit 1

What is lookup change?

0 Answers  

Can you access a repository created in previous version of Informatica?

1 Answers  

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

what is threshold error in informatica?

1 Answers   TCS, Wipro,

How can you access the remote source into your session?

1 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

explain about lookup t/r?

1 Answers   IBM,

What is the status code?

1 Answers  

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

what are the transformations that restricts the partitioning of sessions?

1 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers