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
- 5225 Views
- I also Faced
- E-Mail Answers
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
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is the main role of FI on business
how do u identify the changed records in operational data?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain etl?
explain the methodology of Data Warehousing?(Polaries)
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
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?
How etl testing is different from database testing?
what are the production issues in datastage?
What is fact? What are the types of facts?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Explain what is etl process? How many steps etl contains explain with example?
