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

what r the transformations that r not involved in mapplet?

Question Posted / vidya

Answer Posted / vidya

1.Cobol source definition
2.Joiner transformation
3.Normalizer transformation
4.Sequence generator transformation
5.Pre or Post session stored procedures
6.Target definitions
7.XML source definitions

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a non-reusable instance of reusable transformations?

688

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

633

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6422

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

can we override a native sql query within informatica? How do we do it?

656




How can we create index after completion of load process?

600

How to convert multiple rows to single row (multiple columns) in informatica

901

How to generate sequence numbers using expression transformation?

648

scenario where i can use only concurrent execution of workflow.

2552

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

7825

What is the cumulative sum and moving sum?

760

What is workflow manager?

579

What is informatica powercenter repository?

718

How can we use mapping variables in informatica?

602

Parameter and variable differences

1622