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 much memory (size) occupied by a session at runtime

4 Answers   Wipro,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

What is meta data and system catalog?

2 Answers  

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

What do you understand by SOA of Informatica?

0 Answers  

What is critical mapping?

2 Answers  

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

Why do you use Mapping Parameter and mapping variable?

0 Answers