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 13726

WHAT IS FACT TABLES?

2 6495

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

1 11825

Could any one to tell Fact table Partitioning?

2 6981

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 27612

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

HP,

4 20958

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

HP, TCS,

6 19708

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

HP, Patni,

10 24978

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 12207

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

HP,

5 16750

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

HP,

3 11751

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

CSC, Emphasis,

14 48262

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

CSC, CSE,

4 32425

From where we can start or use pmcmd?

3 9530

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

9 45643

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why do we need informatica?

985

What is aggregator transformation in informatica?

938

What is target designer and target load order?

1101

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8217

Is there any way to read the ms excel datas directly into informatica?

1021

can anyone suggest best free Talend data integration training online

1690

Can we create a node as a gateway node and the same node can be assigned to a grid?

1076

In how many ways we can create ports?

1120

How can we use batches?

1024

what is diff b/t sorter t/r and agg have the option sorter property...

2169

 Informatica Checkpoints

3325

Differentiate between a repository server and a powerhouse?

1116

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1487

Explain how to import oracle sequence into informatica?

1005

What is the advantage of informatica?

1065

For More Un-Answered { Informatica } Questions Click Here