Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

IBM,

6 13483

WHAT IS FACT TABLES?

2 6406

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 11734

Could any one to tell Fact table Partitioning?

2 6826

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

FCS, IBM, Satyam, TCS,

5 27429

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

HP,

4 20786

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

HP, TCS,

6 19456

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

HP, Patni,

10 24679

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

HP,

3 12088

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

HP,

5 16568

Three date formats are there . How to change these three into One format without using expression transformation ?

HP,

3 11609

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

CSC, Emphasis,

14 47759

In real time scenario where can we use mapping parameters and variables?

CSC, CSE,

4 32234

From where we can start or use pmcmd?

3 9396

Whats the difference between $, $$, $$$

9 45306

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the difference between mapping parameter and mapping variable?

986

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1943

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

Separate from an archive server and a powerhouse?

914

What is a grid in Informatica?

1007

Differentiate between source qualifier and filter transformation?

1518

What are junk dimensions?

1032

Explain sessions. Explain how batches are used to combine executions?

960

What are the differences between oltp and olap?

927

Reusable transformation and shortcut differences

1788

What is domain and gateway node?

1126

What is xml source qualifier transformation in informatica?

1184

COM components can be used in Informatica

2321

What can we do to improve the performance of informatica aggregator transformation?

1050

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2266

For More Un-Answered { Informatica } Questions Click Here