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)
I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...
I believe this query is faster than yours....
ReplyDeleteselect * from
(select *,rank over(partition by empno order by version desc) rnk from emp_t a) z
where z.rnk=1
This comment has been removed by the author.
ReplyDeleteI am new to Informatica.
ReplyDeleteCan 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
DeleteHi, Can you plz tell me what is SCD?
ReplyDeleteSCD - Slowly Changing Dimension
Deleteok, thanks!
ReplyDelete@ 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.
ReplyDeleteas your technical query is correct.
if version is not maintained,then how can we get latest record.
ReplyDelete