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
- 5226 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 tracing level and what are the types?
what are the production issues in datastage?
What is partitioning? Explain about round-robin, hash partitioning.
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?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
State the differences between shortcut and reusable transformation
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
What is ROWID explain ?
What is data modeling and data mining?
what is a worklet?
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
Teradata 
