if u can't find what you are looking for in lookup table,
how do you handle?
- 1 Answers
- 4618 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
how do u set partition points in the mapping?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
what are the different Reporting and ETL tools available in the market?
What is lookup table in etl testing?
how do u identify the changed records in operational data?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the difference between OLTP database and data warehousing database?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is the difference between cardinality and Nullability?
what are the session parameters? How do u set them?
Teradata 
