Informatica Interview Questions
Questions Answers Views Company eMail

What is hash partition?

2 6998

How can you define a transformation? What are different types of transformations in Informatica?

10 22991

What is query panel?

1 4920

What is a look up function? What is default transformation for the look up function?

ASM, TCS,

2 16116

What is difference between a connected look up and unconnected look up?

6 23659

What is staging area?

11 23428

What is data merging, data cleansing and sampling?

Satyam,

6 20673

What is up date strategy and what are the options for update strategy?

2 9241

Why do we use DSS database for OLAP tools?

2 5893

What is active and passive transformation?

10 37972

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 18259

How is Data Models Used in Practice?

1 4680

What is the difference between view and materialised view?

4 11689

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

IBM, Wipro,

2 20178

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 36131


Post New Informatica Questions

Un-Answered Questions { Informatica }

How union transformation is used?

579


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

679


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3429


Differences between version 7.x and 8.x.

1401


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1902






Implementation methodology

1247


What is the need of an ETL tool?

628


What are the types of schemas we have in data warehouse.

518


What are the data movement modes in informatica?

686


Is it possible to define a single node as a Gateway node as well as worker node?

639


Suppose we do not group by on any ports of the aggregator what will be the output?

561


Name at least 5 different types of transformations used in mapping design and state the use of each.?

660


Whats the difference between informatica powercenter server, repositoryserver and repository?

659


What is rank transformation in informatica

678


What is meant by LDAP users?

682