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 do you handle decimal places while importing a flatfile into informatica?

1 Answers  

How does the aggregator transformation handle null values?

0 Answers  

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

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  

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

What is partioning?how many types of partinings are there

2 Answers   HCL,

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

What is meant by pre and post session shell command?

0 Answers  

difference between shortcut and reusable transformation?

2 Answers  

how we can update a target table without update strategy and update override?

3 Answers   TCS,

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers