Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is the sql query overwrite in source qualifier in informatica

Informatica,

708

Why union transformation is an active transformation?

Informatica,

751

What are the limitations of joiner transformation?

Informatica,

746

Explain joiner transformation in informatica

Informatica,

770

What are the informatica performance improvement tips

Informatica,

705

What are the mapping parameters and mapping variables?

Informatica,

715

To import the flat file definition into the designer where should the flat file be placed?

Informatica,

747

How are the sources and targets definitions imported in informatica designer?

Informatica,

769

What are the data movement modes in informatica?

Informatica,

792

How to generate or load values in to the target table based on a column value using informatica etl tool.

Informatica,

704

Explain sql transformation in script mode examples in informatica

Informatica,

680

What are Dimensional table?

Informatica,

691

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

Informatica,

751

While importing the relational source definition from the database, what are the metadata of source that will be imported?

Informatica,

907

Explain the mapping variable usage example in informatica

Informatica,

725


Un-Answered Questions { Data Warehouse }

Can you explain model durability?

689


Briefly state different between data ware house & data mart?

652


What is the max core of a component?

690


Describe what the SQL Server tempdb and tlog files are used for?

1913


Fact table is in normalized or de-normalized form?

652






How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

661


Where is teradata rdbms used?

745


in reporting we add some new objects,how we get the count of the newly added objects to the report

1858


Differentiate between datastage and informatica?

844


Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

728


In SAS explain which statement does not perform automatic conversions in comparisons?

924


What is an Integration service in Informatica?

799


How would you join a node to the already existing domain?

793


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1573


What are the six data process products of ab initio (architecture of ab initio)?

768