-
Business Objects cardinalities
Why do we need cardinalities with joins, when we are able to get the data with joins only?
-
Framework Manager
What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Shortcut join
A join that links two tables by bypassing one or more other tables in the universe.
-
Hierarchy
An ordered series of related dimensions used for multidimensional analysis.
-
Document domain
The area of the repository that stores documents, templates, scripts, and lists of values.
-
Class
A logical grouping of objects and conditions within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.
-
Cardinality
Expresses the minimum and the maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0,1, or N.
-
Alias
A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
-
Importance of Surrogate Key in Data warehousing?
Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.
-
What is a command that used to run a batch?
pmcmd is used to start a batch.
-
What is DTM process?
After the loadmanger performs validations for session,it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread.Master thread creates and manges all the other threads.
-
What r two types of processes that informatica runs the session?
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
-
How can u recognise whether or not the newly added rows in the source r gets insert in the target ?
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range
-
What r the mapings that we use for slowly changing dimension table?
Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table. Type 2: The Type 2 Dimension Data mapping inserts both...
-
What is the default join that source qualifier provides?
Inner equi join.
-
What is source qualifier transformation?
When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session.
-
Differences between connected and unconnected lookup?
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or static cache U can use a static cache.Cache includes all lookup columns used in the mapingCache includes all lookup out put ports in the lookup condition and the lookup/return port. Support user defined...
-
How many ways u create ports?
Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.
-
How can you create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat...
-
What is a Source Qualifier?
It represents all data queried from the source.
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
-
What are Target Types on the Server?
Target Types are File, Relational and ERP.