Answer / ravikumar2614

srikanth answer will work only if the table having only 4 records which r same.
if the table having 10 records, and 4 records r same out of 10 (1st, 5th, 6th, 8th records r same)
in above situation srikanth solution will not work
if wrong please correct me on ravi.info2614@gmail.com

Answer / divesh chasta

informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0

from this we can get third record.

Answer / guest

Based on the empid(assuming the persons are employees) us
can fire a quiry on that id.

Answer / pooja

hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3

Answer / rag

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

how can import the data from the flat files?

2 Answers  

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

How to recover sessions in concurrent batches?

3 Answers  

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

What are the join types in joiner transformation?

1 Answers   Informatica,

All active transformations r passive or not?

7 Answers  

what is lookupoverriding?

1 Answers  

explain about lookup t/r?

1 Answers   IBM,

8.what is mapplet ?give example?

2 Answers  

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,