when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/
Answer Posted / jack
Lookup SQL override will help you to achieve this
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
What is enterprise data warehousing?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Mention few power centre client applications with their basic purpose?
What is the difference between Active and Passive transformation?
What are the types of data warehouses?
what are 3 tech challenges/ common issues you face?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How would you copy the content of one repository to another repository?
What is persistent lookup cache?
What are the different clients of powercenter?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to do the error handling of if ur source is flatfiles?
What is intricate mapping?
list out all the transformations which use cache?