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

hw cn v elimate dublicate values from lookup without
overriding sql?

Question Posted / surender

Answer Posted / surender

yes correct

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

592

What differs when we choose the sorted input for aggregator transformation?

575

Explain your project of banking domian.

1220

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8566

What is DR strategy for Informatica project?

705




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

7819

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741

If informatica has its scheduler why using third party scheduler?

778

Parameter and variable differences

1618

What is event and what are the tasks related to it?

619

what is informatica metadata?

607

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1533

difference between informatica 8.1.1 and 8.6

3246

What are data-driven sessions?

716

What is joiner transformation?

585