-
ETL Load Frequency and Load Window
What is Load Frequency and Load Window in ETL?
zann1
- Sep 7th, 2009
ETL Load frequency is how often the ETL processes (that load data into the data warehouse) are run.Load Window is the time allocated for ETL load to execute.e.g. If the load is run daily, and the time allowed for execution is 8 hours then:ETL load frequency = dailyLoad window = 8 hours
-
Lookup Performance
How does the usage of Dataset improve the performance during lookups?
sixto.dsilva
- Aug 17th, 2009
Correct me if i misunderstood your question. I think you want to know whether the usage data will improve the graph performance. I think definitely the usage of data will definitely improve the graph ...
-
Data Warehouse as Transaction Database
Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not?
sixto.dsilva
- Aug 15th, 2009
As the definaton of Datawarehouse say it is repository of historial data which is used by Busines users to run some reports on his/her area of interests.Data is not loaded everyhour or every mtes in D...
SQLGal
- Jun 7th, 2009
No, a data warehouse cannot by definition be used as a transaction database. A data warehouse is "read only" data that does not change once it has been loaded and used for informa...
-
Reconcialation Process
What is the Reconcialation Process?
v_madhu29
- Aug 11th, 2009
Reconcilation process is a systematic comparision between the data in Dataware house and data in source system.The comparision may be a set a predefined summary values or detailed data periodically.
-
Multi-Valued Dimension
Illustrate one detailed example for multi-valued dimension or bridge table?
ramanapaidi
- Jul 1st, 2009
Health care bill has line item of diagnosis, for which there could be multiple values
-
What is the difference between mapping parameter & mapping variable in data warehousing?What are the types of variable available in data warehousing?
dhiveya.m
- Apr 22nd, 2009
Mapping parameter are the constant values (values never changes) and mapping variables are the values that ever changes.
fir_dan
- Jul 18th, 2008
A mapping parameter is a static value that you define before running the session and it retains the same value till the end of the session. Define a parameter in paramaeter file (.par) and use it in m...
-
DataStage TX
What is DSTX?
mercmorrow
- Jan 21st, 2009
Probably a late answer now, but... Datastage TX a rebranding of the Mercator runtime(Event Server) application by the (then) owners Ascential.Since then IBM have taken over Ascential, and the product ...
-
ERWIN Tool Model Print
If you take a print out of your model in ERWIN tool, What all you will be able to see?
rajeshkumar.san
- Dec 26th, 2008
According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow.
-
How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??
uma
- May 17th, 2007
There are 3 types of schemasstar schemasnowflake schemaand galaxy schemabyuma
-
Pivot Table inside Informatica
How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?devidya
- Sep 25th, 2008
Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.
-
Difference between Database and Datawarehouse
What are the difference between a database and data warehouse?
gtomar
- Jul 28th, 2008
Database :- database is a collection of related information stored in a structured form in terms of table so that It makes easier insertion, deletion and mainupulation of data. database consist of tab...
ashuboy12345678
- Jul 27th, 2008
Database is a collection of mostly recent data. Where as Datawarehouse consist of historical data the size can vary upto 100 GB or more.Datawarehouse is a combination of datamart used mainly knowledge processing.
-
Parameter file in mapping
How to create parameter file and how to use in a mapping and workflow? Explaon with eg
ARUL_P
- Jul 28th, 2008
Hi, When a session starts to run, it checks for the database connectivity in the session properties. Alternatively, this details are stored in a Parameter file(a text file) and is stored in a particul...
-
OLAP tools and Reporting tools
What is the difference between OLAP tools and reporting tools?
sinisdevan
- Jul 10th, 2008
By using OLAP tools you will be able to create a symantec layer of datamarts on which we can run reports.
-
Look Up Tables
What are lookup tables? Why they are used? Where they are used?
ponnarasuk
- Jul 9th, 2008
When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table
-
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&...
-
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...
-
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.
-
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 critical column?
Anitha
- Feb 23rd, 2007
The columns(granular) that change the values over a perriod of time.
-
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
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans