-
Value prompt disadvantages
What are the disadvantages of value prompt?
-
Can we partition the Universe? If yes then How?
-
OLAP and OLTP
What is the difference between OLAP and OLTP?
Pardeep Kaur
- Jan 31st, 2008
OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are m...
-
Clustering and Classification algorithms
How to implement clustering and classification algorithms in data mining
-
Developing and Designing
Does the ETL developer involve in physical database design and logical database design. Are these developer duties?
-
Increase row level limit of Cognos Query Reports
How can we increase the row level limit of cognos query reports?This deals with the administrative part of impromptu.
-
-
-
1).briefly state different between data ware house & data mart?2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?3).What is meta data?
surajkm99
- Feb 4th, 2008
1) Difference Between Data Warehouse & Data MartIn Simple Terms Data warehouse : is a SUBJECT - ORIENTED, TIME VARIENT, NON-VOLATILE, INTEGRATED Collection of Data, In Support of Management ...
-
Clustering and Sampling
What is the difference between Clustering and Sampling
-
How can you implement many to many relation in star schema model?
gopal
- Jan 25th, 2007
HiUpto my knowlege designers implementing this M-M relation asFirst break the schema to 1-M and M-1 relationsLet me correct if any thing is wrong
-
Create Parameters in Concurrent Program
How to create parameters in concurrent program for "HOST" executable type
-
What is critical column?
Anitha
- Feb 23rd, 2007
The columns(granular) that change the values over a perriod of time.
-
Suppose your filtering the rows using a filter transformation only the rows meet the condition pass to the target .Tell me where the rows will go that doesnot meet the condition.Thanks in advance
VVM.SP
- Mar 18th, 2008
In Filter Transformation Those row are not meet to the filter condition they are rejected. These rejected rows are appear in $PMBad.Dir
herbert
- Dec 9th, 2006
Yes there is folder or file in informatica which collects this rejected rows, its location is given while installing the s/w
-
What is the use of data warehousing? Can we perform all the transformations using Oracle?
rmanikandan
- Apr 30th, 2008
Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle
prudhvi.g
- Sep 3rd, 2007
Datawarehousing is nothing but analysing the data and providing solutions to the business people.Major usage of datawarehousing is that it can analyse the data and stored the data which is historical.
-
Meta Data and Data Dictionary
What are the differences between Meta Data and Data Dictionary?
jryan999
- May 1st, 2008
The “data dictionary” in a database tool (eg. Oracle or Informatica) is simply a repository of metadata. Metadata is however data about the data. The following are examples of m...
pal.amol
- Feb 26th, 2008
HI Metadata is nothing but the data about data , if you take term of informatica in that through metadata only you will be converting or solving the problem. In the flow of Informatica mapp...
-
-
Session log, Task and Workflow Manager
What is a Session log, task in Informatica.
What is the work of Session log and workflow manager.ambika shanmugam
- May 20th, 2008
Session Log:The session log contains the status of the job whether it is running or abended or good end. And also the information about the every step execution.Task: This is the stage for&...
-
-
Dimensional Model for Internet Sales
How to prepare dimensional model for internet sales?What are the business requirements for internet marketing/sales/
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans