if u can't find what you are looking for in lookup table,
how do you handle?
Answer Posted / raj.arjunan
This Depend on the situation,
To Check the value is there or not there two ways
1. Use notfound function (if possible)
2. Check the Key value from lkp as NULL
Than based on the requirement generate error/Put default
value
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the difference steps for data modeling?
What are various etl tools in the market?
What is tracing level? How many types of transformations supported by sorted input?
what is pmrep command?
What is grain of fact?
flat filevalidation in informatica
explain the methodology of Data Warehousing?(Polaries)
Explain me ETL project architecture in Detail?
What are the different Lookup methods used in Informatica?
What is tracing level?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is full load & incremental or refresh load?
What are the three tiers in etl?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is a worklet?