Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 22121 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Based on the empid(assuming the persons are employees) us
can fire a quiry on that id.
| Is This Answer Correct ? | 0 Yes | 7 No |
Answer / pooja
hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3
| Is This Answer Correct ? | 0 Yes | 14 No |
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
| Is This Answer Correct ? | 1 Yes | 21 No |
what are 3 tech challenges/ common issues you face?
What is the reusable transformation?
What are the challenges you have faced in your project?
difference between informatica 8.1.1 and 8.6
What is the use of incremental aggregation?
Can we get 1st record through Informatica(without sequence number).
why we use informatica in our project?
In any project how many mappings they will use(minimum)?
How to load last n records of file into target table - informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Teradata 
