Answer Posted / sabyasachi
Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to load a Dimension ? and how to load a fact table?
How to do unit testing in informatica? How to load data in informatica ?
Where do we use mapping variables in informatica?
What is repository manager?
What is rank transform?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
EXL informatica Questions
generate date / time dimension in informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Why do you use Mapping Parameter and mapping variable?
How can we handle two sessions in informatica?
Define update strategy?
What is standalone command task?
How to differentiate between the active and passive transformations?