Sign Up Login


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

replace multiple spaces with single space.

Question Posted / pushpendra

Answer Posted / pushpendra

replacechr function can use.

replacechr(0,Column_Name,' ','')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by blocking transformation?

779

How can we store previous session logs?

783

Can you use flat files in Mapplets.

2416

Write the unconnected lookup syntax?

835

How can we use mapping variables in informatica? Where do we use them?

837

Explian the Process of deployment groups in informatica

825

What if the source is a flat-file?

822

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2131

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

964

What's the layout of parameter file (what does a parameter file contain?)?

2178

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

8445

How many transformations can be used in mapplets.

1672

Separate from a database, an information bazaar, and an information stockroom?

833

Design time, run time. If you don't create parameter what will happen

1625

what is song in infrmatica...?

1921