what is parallel querying and what r hints.
Answer / 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 |
How can you recover the session in sequential batches?
what is the exact meaning of domain?
have you developed documents in your project? and what documents we develop in realtime?
Explain the informatica workflow?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is rank index in rank transformation?
Differentiate between source qualifier and filter transformation?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
What is difference between stored procedure transformation and external procedure transformation?