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 13752

WHAT IS FACT TABLES?

2 6499

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

1 11844

Could any one to tell Fact table Partitioning?

2 6991

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 27639

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

HP,

4 20969

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

HP, TCS,

6 19728

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

HP, Patni,

10 25008

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 12218

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

HP,

5 16769

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

HP,

3 11761

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

CSC, Emphasis,

14 48329

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

CSC, CSE,

4 32438

From where we can start or use pmcmd?

3 9544

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

9 45684

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1107

Can you use flat files in Mapplets.

2651

server hot-ws270 is connect to Repository B. What does it mean?

2565

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068

What is a sequence generator transformation?

1021

What is the difference between writing a joiner query in ANSI style and THETA style?

2379

Performance tuning in UNIX for informatica mappings?

2568

Explain in detail scd type 2 through mapping.

1041

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2073

what is mean by complex business rule ?

2162

What the difference is between a database, a data warehouse and a data mart?

1155

What are the differences between joiner transformation and source qualifier transformation?

1171

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

What are the differences between source qualifier and joiner transformation?

1062

What is resilience time?

1139

For More Un-Answered { Informatica } Questions Click Here