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 7371

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 4298

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 16742

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

CTS,

2 9187

why we use stored procedure transformation?

IBM,

4 9059

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

1 4321

What is the need of building a data warehouse?

2 4830

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 6516

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 3674

what is data driven in informatica

IBM,

5 9513

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to create a non-reusable instance of reusable transformations?

1135

what is $$$$?

2161

How does a rank transform differ from aggregator transform functions max and min?

1207

What is workflow? What are the components of workflow manager?

1178

How union transformation is used?

1006

What is enterprise data warehousing?

1049

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2123

What is the sequence generator transformation in informatica?

1184

What is event and what are the tasks related to it?

1122

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

What is the benefit of partitioning a session?

1182

What can we do to improve the performance of informatica aggregator transformation?

1095

How we can create indexes after completing the loan process?

1211

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

can we override a native sql query within informatica? Where do we do it?

1122

For More Un-Answered { Informatica } Questions Click Here