Best Website For Interview
Page 1 of 1
Best Website For Interview
Hai all,,,
Here are some important Data Warehousing Interview Questions & Answers.
1.What is the difference between datastage and informatica
Ans: The main difference is Vendors. Each one is having plus from their architecture. For Datastage it is a Top-Down approach. Based on the Businees needs we have to choose products.
Main Difference is
In DataStage having
Partition,
parallelism,
File Lookup,
Merge/Funnel.
Informatica:
No concept of partition and parallellism
File lookup caching is really horrible. It will take more time do a lookup with other tables.
There is no concept of merge/Funnel options.Here only available union and union all function.
These are the main differences.
2.What is merge and how it can be done plz explain with simple example taking 2 tables .......
Ans: Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp,Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables.
more details....
Here are some important Data Warehousing Interview Questions & Answers.
1.What is the difference between datastage and informatica
Ans: The main difference is Vendors. Each one is having plus from their architecture. For Datastage it is a Top-Down approach. Based on the Businees needs we have to choose products.
Main Difference is
In DataStage having
Partition,
parallelism,
File Lookup,
Merge/Funnel.
Informatica:
No concept of partition and parallellism
File lookup caching is really horrible. It will take more time do a lookup with other tables.
There is no concept of merge/Funnel options.Here only available union and union all function.
These are the main differences.
2.What is merge and how it can be done plz explain with simple example taking 2 tables .......
Ans: Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp,Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables.
more details....
meena- Posts : 125
Join date : 2011-07-03
Similar topics
» Excellent Website For Interview
» Interview Success Kit - 9,000 Interview Questions & Answers
» Best website for MBA
» Best Website for Getting the Project Code
» Job Related Excellent Website
» Interview Success Kit - 9,000 Interview Questions & Answers
» Best website for MBA
» Best Website for Getting the Project Code
» Job Related Excellent Website
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum