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 |
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
Define Dynamic push down optmization?
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
Compare etl & elt?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what is session partitioning?
What is Relational Integrity?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Explain do we need an etl tool? When do we go for the tools in the market?
What are the ETL Testing Operations?
How we can see table structure?
Can u access a repository created in previous version of Informatica?