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 13956

WHAT IS FACT TABLES?

2 6619

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

1 11923

Could any one to tell Fact table Partitioning?

2 7134

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 27789

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

HP,

4 21139

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

HP, TCS,

6 19945

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

HP, Patni,

10 25340

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 12341

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

HP,

5 16941

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

HP,

3 11856

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

CSC, Emphasis,

14 48921

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

CSC, CSE,

4 32630

From where we can start or use pmcmd?

3 9676

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

9 46007

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we handle two sessions in informatica?

1098

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1994

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3929

What does reusable transformation mean?

1199

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1216

what is the size of u r source(like file or table)?

2312

What is confirmed fact in dataware housing?

7111

which one is better performance wise joiner or look up

1155

wf dont have integration severances how you can run?

1991

What is deployment group?

1304

What is olap (on-line analytical processing?

1112

How can you validate all mappings in the repository simultaneously?

1429

Define filter transformation?

1151

What is a joiner transformation?

1038

How we can create indexes after completing the load process?

1205

For More Un-Answered { Informatica } Questions Click Here