sunil

• Feb 27th, 2007

 

you can write a query like inline view clause you can compare previous version to new highest version then you can get your result 

sanghala

 Profile Answers by sanghala Questions by sanghala

• Mar 1st, 2007

 

hi Sunil,

Can u please expalin your answer some what in detail ????

Hanu Ch Rao

• Mar 1st, 2007

 

Hi,

Assume if you put the surrogate key in target (Dept table) like p_key and
version field, dno field and loc field is there
then

select a.p_key, a.dno, a.loc, a.version from t_dept a
where a.version = (select max(b.version) from t_dept  b where a.dno=b.dno)

this is the query if you write in lookup it retrieves latest (max)
version in lookup from target. in this way performance increases.
 

ketannp

 Profile Answers by ketannp 

• Feb 9th, 2008

 

Select Acct.*,Rank() Over ( partition by ch_key_id order by version desc) as Rank
from Acct
where Rank()=1

dl_mstr

 Profile Answers by dl_mstr 

• Feb 9th, 2008

 

select business_key,max(version) from tablename group by business_key