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 7317

what is the size of your data warehousing?

IBM,

2058

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

IBM,

2086

what is the dashbords?

IBM,

1 4235

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

IBM,

1 4843

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

TCS,

3 16633

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

CTS,

2 9077

why we use stored procedure transformation?

IBM,

4 8896

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

1 4261

What is the need of building a data warehouse?

2 4727

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 4086

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

3 6402

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 3824

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 3597

what is data driven in informatica

IBM,

5 9329

Post New Informatica Questions

Un-Answered Questions { Informatica }

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1019

How to generate or load values in to the target table based on a column value using informatica etl tool.

1035

Explain sessions?

997

What is main use of mapplet?

1088

What are the features of complex mapping?

1110

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1456

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2152

What is the difference between router and filter?

1177

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2014

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

8177

difference between repository database and repository service?

1096

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1106

What are different types of transformations available in informatica?

953

what is $$$$?

2104

What are the restrictions of union transformation?

995

For More Un-Answered { Informatica } Questions Click Here