Interested to Buy Any Domain ? << Click Here >> for more details...
if u can't find what you are looking for in lookup table,
how do you handle?
- 1 Answers
- 5162 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 |
what is the use of server manager?
what are business components in Informatica?
How to know informatica conslole password??
what is data modeling?
Do we need an ETL tool? When do we go for the tools in the market?
how do u automate Extraction process?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is etl process. How many steps etl contains explain with example?
What are the ETL Testing Operations?
what are the reporting tools and difference between them?
dimension object created in oracle can be imported in designer?how?
Teradata 
