Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

wht is cdc?how to use it in creation of mappings?

HSBC,

6 23176

wht target override?wht advantages it has compare to target update?

Polaris,

2 13930

how to calculate the optimum cache size in aggregator transformation?

1 7917

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9248

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20179

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9741

How to delete duplicate record in Informatica?

7 30604

What is the difference between view and materialised view?

6 14660

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 7126

how many types transformations supported by sortedinput?

4 8544

what is lookupoverriding?

1 5964

what is the process of target load planing?

IBM,

2 6783

what is the process we used in joiner transformation,there is no matching column in sources?

2 6953

what is the diff b/w union and joiner and lookup?

4 14778

how can u load the data in time dimension?

3 12458

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to handle decimal places while importing a flatfile into informatica?

1244

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2026

How to configure mapping in informatica?

1226

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

9309

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1962

Could you explain what is enterprise data warehouse?

1230

Please let me know how to make encryption and decryption with example?

1950

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

1263

What could be the possible resons of locks by user?

1146

How do you load unique records into one target table and duplicate records into a different target table?

1321

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1189

In how many ways we can create ports?

1162

What is the function of union transformation?

1207

How we can create indexes after completing the load process?

1205

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

2188

For More Un-Answered { Informatica } Questions Click Here