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 7365

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 4907

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

TCS,

3 16740

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

CTS,

2 9184

why we use stored procedure transformation?

IBM,

4 9052

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 9505

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are pre and post-session shell commands?

1311

What is a connected transformation?

1118

Is stop and abort are same in informatica?

1001

What do mean by local and global repository?

1226

What is the session task and command task?

1054

Explain the aggregator transformation?

1164

What is blocking transformation?

1144

What are the different options available for update strategy?

1003

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2047

What are the types of caches in lookup?

1048

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1049

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1039

Explain the different dimensions.

965

which one is better performance wise joiner or look up

1093

For More Un-Answered { Informatica } Questions Click Here