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 11238

WHAT IS FACT TABLES?

2 5461

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

1 11038

Could any one to tell Fact table Partitioning?

2 5391

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 25416

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

HP,

4 19111

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

HP, TCS,

6 17487

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

HP, Patni,

10 21881

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 10722

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

HP,

5 14853

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

HP,

3 10429

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

CSC, Emphasis,

14 43881

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

CSC, CSE,

4 30360

From where we can start or use pmcmd?

3 8356

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

9 42533


Post New Informatica Questions

Un-Answered Questions { Informatica }

Global and Local shortcuts. Advantages.

1438


Write the advantages of partitioning a session?

729


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

606


Have you worked with/created Parameter file

1199


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5195






What is flashback table ? Advance thanks

1461


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

649


What is Cognos script editor?

3765


What is session task and command task?

624


What is pmcmd command?

645


What is the difference between informatica 7.0 and 8.0?

548


What are the main features of Oracle 8i with context to datawarehouse?

1662


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

783


Explain Dataware house architecture .how data flow from intial to end?

2097


Enlist the differences between database and data warehouse.

516