Skip to main content

Retrieve the latest record (scd) in Informatica

By



If we are using emp table as target in scd then the query is



Select * from emp_t a

where a.version = (Select max (b.version) from emp_t b where a.empno=b.empno)
Labels:

Comments

  1. Unknown26 March 2014 at 02:25

    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) z
    where z.rnk=1

    ReplyDelete
  2. LONELINESS9 June 2014 at 12:42

    This comment has been removed by the author.

    ReplyDelete
  3. Unknown9 June 2014 at 12:46

    I am new to Informatica.
    Can you please tell me a and b in the query.
    Is a the target lookup table?

    ReplyDelete
    Replies
    1. Unknown8 July 2014 at 04:00

      a and b are alternative names(alias names) for emp_t

      Delete
  4. subin12 August 2014 at 05:43

    Hi, Can you plz tell me what is SCD?

    ReplyDelete
  5. subin18 August 2014 at 05:23

    ok, thanks!

    ReplyDelete
  6. Anonymous8 October 2014 at 11:31

    @ 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.

    ReplyDelete
  7. Techie geek9 June 2016 at 03:44

    if version is not maintained,then how can we get latest record.

    ReplyDelete

Post a Comment