I believe this query is faster than yours....select * from (select *,rank over(partition by empno order by version desc) rnk from emp_t a) zwhere z.rnk=1
This comment has been removed by the author.
I am new to Informatica.Can you please tell me a and b in the query.Is a the target lookup table?
a and b are alternative names(alias names) for emp_t
Hi, Can you plz tell me what is SCD?
SCD - Slowly Changing Dimension
@ adesh if they are asking that questions from SCD related,that is scd 2 ,where old and new data are identified by version then,giving answer in interview in using rank query will be wrong,they will get to know that you dont know SCD,which is important in informatica.as your technical query is correct.
if version is not maintained,then how can we get latest record.
Copyright © 2015 mkashu. Designed by Templateism