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
- 21157 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 |
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is log file,and where is it located,why u r using the log file
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
what is the size of your data warehousing?
What is a sorter transformation?
how to move the mappings from your local machine to claint place?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
Teradata 
