Sign Up Login


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

what are the reusable tasks in informatica ?

Question Posted / shashi

Answer Posted / shashi

SESSION TASK
COMMAND TASK
EMAIL TASK

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In development project what is the process to follow for an etl developer from day1

1485

Please let me know how to make Data masking in informatica..

1479

what are 3 tech challenges/ common issues you face?

2112

Explain the difference between mapping parameter and mapping variable?

808

What are the static cache and dynamic cache in informatica?

970

What is the advantage of informatica?

831

What are the components of the workflow manager?

896

What are batches?

816

Explain the different kinds of facts.

751

Difference between Data and Index Caches?

873

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

1900

how to load rows into fact table in data warehouse

895

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

8454

Why do you use Mapping Parameter and mapping variable?

1482

Why union transformation is an active transformation?

858