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 |
Different sorts of metadata that stores in the storage facility?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
How to elaborate powercenter integration service?
If I have a index defined on target table and if set it to bulk load will it work ?
how do u move the code from development to production?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How you load distinct records into one target and duplicate records into another target?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What is critical mapping?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size