WHat all joins are there in Source Qualifier?
Answer / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
Is This Answer Correct ? | 0 Yes | 0 No |
What is the different lookup cache(s)?
How to get EVEN & ODD numbers separately?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
what is semi-additive fact?where did u used?
What is confirmed dimension and fact?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Explain how many types of dimensions are available in informatica?
What is the use of an aggregator cache file?
can any one explain me about junk dimension
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,