In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / abhishek
U can achive this by using row_number function in source
qualifer example
select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3
or by rank t/r in mapping
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
What is blocking transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the need of etl tools?
What is transformation?
What is dimensional table?
What is dynamic cache?
What is a dimensional model?
What do you mean by enterprise data warehousing?
What is an active transformation?
What is informatica powercenter repository?
State the limitations where we cannot use joiner in the mapping pipeline?
How to join three sources using joiner? Explain though mapping flow.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?