Explain how to import oracle sequence into informatica?

1011

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

9133

What is meant by lookup transformation? Explain the types of lookup transformation?

950

Can we get 1st record through Informatica(without sequence number).

1479

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1052

lookup transformation with screenshots

4006

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

Briefly explain the aggregator transformation?

1008

Under which circumstances, informatica server creates reject files?

1095

tell me the rules and responsblites in our project(my project is development)

1933

What are some examples of informatica etl programs?

942

How to use procedural logic inside infromatica?

1236

How to create or import flat file definition in to the warehouse designer?

1070

Explain why we use partitioning the session in informatica?

1092

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079