In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
Answer Posted / sukanta
The interviewer just check your knowledge about Informatica
Lookup Transformation.
If you disable cache you can't override the default sql query.
Follow Informatica Help.
Regards
Sukanta
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
What do think which one is the better joiner or look up?
Differentiate between a repository server and a powerhouse?
Enlist few areas or real-time situations where informatica is required.
design of staging area?
what is $$$$?
expain about the tune parameters?
Explain sessions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is meant by a domain?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Sequence generator, when you move from develoment to production how will you reset
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Define pmcmd command?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?