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

how to delete duplicate records by using filter transfermation?

3 Answers  

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

Diffrence between static and dynamic cache

2 Answers   HCL,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

What is aggregator transformation in informatica?

0 Answers  

What is the status code in stored procedure transformation?

0 Answers   Informatica,

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

what is confirmed dimension?

6 Answers  

Differentiate between sessions and batches?

0 Answers  

which quality process u can approach in ur project

1 Answers   CTS,

What is an active transformation?

0 Answers   Informatica,

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers