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 7459

what is the size of your data warehousing?

IBM,

2146

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

IBM,

2188

what is the dashbords?

IBM,

1 4371

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

IBM,

1 5002

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

TCS,

3 16898

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

CTS,

2 9299

why we use stored procedure transformation?

IBM,

4 9222

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

1 4409

What is the need of building a data warehouse?

2 4952

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 4257

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

3 6651

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 3974

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 3771

what is data driven in informatica

IBM,

5 9701

Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the advantages of informatica.

1102

What is native users?

1227

How to generate sequence numbers without using the sequence generator transformation?

1268

How do you load only null records into target? Explain through mapping flow.

2077

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2074

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1963

What is a router transformation?

1217

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4152

 Informatica Checkpoints

3380

list out all the transformations which use cache?

1242

What is the need for an etl tool?

1105

How we can create indexes after completing the loan process?

1253

Explain the types of transformations?

1106

What is mapplet in informatica?

1132

For More Un-Answered { Informatica } Questions Click Here