query to Compare data of two tables between two different Databases(Oracle and SQL Server)
Eg.,
Source Database: Oracle
Table: Employee
Target Database : SQL Server
Table : emp
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
What is the difference between primary and candidate key?
Explain database partitioning. What is its importance?
What is ole db used for?
What are the two categories of Client-Server application development?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
Does facebook use graph database?
1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
give a simple example of physical and logical data independence
Clipper / DBF error
How do you pass parameter in stored procedure?