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 7320

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 4236

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

IBM,

1 4844

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

TCS,

3 16635

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

CTS,

2 9080

why we use stored procedure transformation?

IBM,

4 8901

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

1 4263

What is the need of building a data warehouse?

2 4728

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 6403

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 3825

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 3599

what is data driven in informatica

IBM,

5 9331

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a surrogate key?

1029

How many ways are there to do 'remove duplicate records in informatica'?

969

Can we create two repositories on same database instance in oracle?

1044

How to start a workflow using pmcmd command?

1199

What is mapplet in informatica?

997

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8983

Explain the difference between a data warehouse and a data mart?

1022

what is song in infrmatica...?

2182

Explain in detail about scd type 1 through mapping.

1308

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6949

Why sorter is an active transformation?

1144

Explain the aggregator transformation?

1109

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8154

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

1006

Where are the source flat files kept before running the session?

1028

For More Un-Answered { Informatica } Questions Click Here