1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi all,

Can you please send me the Dimensions and fact tables
which are used in mutual fund project. and please send me
the brief summary about the project.

Please do the needful.

Question Posted / nag

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

explain abt joiner t/r?

1 Answers   IBM,

connected and unconnected lookups?

4 Answers  

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 Answers  

In a concurrent batch if a session fails, can you start again from that session

1 Answers  




What is souce qualifier transformation it is active or passive

2 Answers   HCL,

where is the reject loader .

1 Answers  

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

differences between service based and product based?

0 Answers   Satyam,

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

4 Answers   CSC,

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

What are the new features of Power Center 5.0?

0 Answers  

For more Informatica Interview Questions Click Here
Categories