if u can't find what you are looking for in lookup table,
how do you handle?
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 session partitioning?
Explain about enterprise scalability and roi of data integration suite?
Explain different types of partitioning?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
Mention few test cases and explain them?
What is full load & incremental or refresh load?
how do u set the size of block buffer?
what happens if the info.server doesn't find the session parameter in the parameter file?
Identifying the bottlenecks in various components of Informatica and resolving them.
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 make u disappointmnets in u r career
what are the session parameters? How do u set them?