-
Cardinality
What is Cardinality? What are the different types of Cardinality? How will you define Cardinality to outer join, left join, right join, inner join, fact to fact and dimension to dimesion?
-
Real Time Data Warehousing
What is Real-Time Data Warehousing?
-
Content Store on Network
How to create content store in the network and how to connect the remote database?
-
Version Control
How to use version control. What are the options which is use in the version control
-
Data Warehouse Security
How data security is provided in Data Warehouse?
-
Data Table Compare Values
How to compare values in data table?
-
Data Warehousing Life Cycle
What is the life cycle of Data Warehousing in Real-time?
-
Mimic Diagram
What is meant by mimic diagram? Where it is used?
-
Use of ROLLUP and CUBE
What is a use of ROLLUP and CUBE in ORACLE? How do they help Data Warehousing applications?
-
Information Gain Concept
How to remove a particular attribute from table using the information gain concept?
-
Custom Dimensions
What is a custom dimension?
-
Fact Table Duplicates
How can we remove duplicates from fact table?
-
Rejected Data
How to get rejected data from the join stage without using any stages after join?
-
Prioritized Rules
What are the prioritized Rules in Transform function?
-
Central Repository
What is the Central Repository? Is it possible to login from designer?
-
Rejected data loading
How can I load rejected data file?
Is it necessary to create new mapping for that.....How can I load by reject data utility explain me clearly -
How do we increase Hash file size?
How do we increase Hash file size?
-
Sequencer
How to create sequencer in datastage(parallel)?
-
Master data
Can any one explain about master data? and we use it frequently or rarely.
-
Informatica project overview
As I am new to Informatica. Can anybody tell me about real time
Informatica project in detail(step by step). Explain it by giving example.
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans