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

Informatica Interview Questions

Questions Answers Views Company eMail

explain about informatica server architecture?

IBM,

1 7366

what is the size of your data warehousing?

IBM,

2095

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

IBM,

2136

what is the dashbords?

IBM,

1 4297

what is the drillup & drill down?and use of the drill up and drill down?

IBM,

1 4909

how the informatica server sorts the strings values in rank transformations?

TCS,

3 16741

what are the output files that the informatica server creats during running a session?

CTS,

2 9185

why we use stored procedure transformation?

IBM,

4 9055

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 4319

What is the need of building a data warehouse?

2 4829

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

IBM,

1 4160

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 6514

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 3894

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 3672

what is data driven in informatica

IBM,

5 9507

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly describe lookup transformation?

1046

What is meant by pre and post session shell command?

1159

How might you approve all mappings in the archive all the while?

1018

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

Explain how many types of dimensions are available in informatica?

1098

What is a transaction control transformation?

1208

Why is sorter an active transformation?

1129

What are connected or unconnected transformations?

1123

How to create Target definition for flat files?

1225

define galaxy repository in informatica

2228

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

what is informatica metadata?

1037

How do you convert single row from source into three rows into target?

1157

Explain what are the different versions of informatica?

1097

For More Un-Answered { Informatica } Questions Click Here