suppose data is copie to oracle to sql by using DTS.
Actully it taken 2 hours. suppose some day distribute the
server in the middle of 2 hours. after how can i get the
data ?
I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz...
What is the difference between referencing and joining?
85
How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?
what is the full procedure for using store procedure in
informatica7.1?
40
from where do u receive the information to develop report
47
When the mutating error will comes? and how it will be
resolved?
31
Please suggest me any course and institute which provide
training on the below skills.
• Knowledge of data extraction concepts and tools
• QMF (query management facility)queries
• Experience and expertise in QMF queries
• Excellent ability to write, read, and interpret QMF
queries against the Source Data Warehouse base level (daily
and monthly) and month-end affinity comp tables
• RDBMS & ER
• Knowledge of Relational Databases (RDBMS) and
Entity Relationship (ER) Diagrams
• SOURCE Data Warehouse
• Experience and expertise in Source Data Warehouse
or data warehouses on the mainframe.
• MS SQL Server
• Experience in MS SQL Server
• Excellent skill in writing/interpreting SQL queries
and running Data Transformation Services (DTS) or open
query packages.
• Knowledge of writing/interpreting Visual Basic code.
48
What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes?