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 |
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
In Which Transformation We Can Use Having Clause In Informatica?
Can u access a repository created in previous version of Informatica?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
When do we analyze the tables? How do we do it?
what is meant by drill through?(Mascot)
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
explain the methodology of Data Warehousing?(Polaries)
What is data modeling and data mining?
what are variable ports and list two situations when they can be used?
Can u access a repository created in previous version of Informatica?
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,