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 parallel querying and what r hints.

1 Answers  

what is the exact meaning of domain?

3 Answers  

what is the difference between stop and abort?

3 Answers   TCS,

How can you complete unrcoverable sessions?

1 Answers  

What is a command that used to run a batch?

2 Answers  

How do you do error handling in Informatica?

1 Answers  

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

what is bridge tables in informatica

1 Answers   CTS,

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

Is it possible to revert a global repository to local one and why?

0 Answers  

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers