Interested to Buy Any Domain ? << Click Here >> for more details...
Find a way to implement the following logic :
You have column like :
Column 1
AA|BB|CC
DD|EE|FF
WW|AA
I need to get the length of the column without the ‘|’ .
- 5 Answers
- 9737 Views
- I also Faced
- E-Mail Answers
Answer Posted / hariprasad_pulluru
Hi,
You can also parse the string using replace chr to
elminate '|' and find the length of the column
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain your project of banking domian.
Why union transformation is an active transformation?
What is confirmed fact in dataware housing?
can anyone suggest best free Talend data integration training online
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the fact table?
What is a repository? And how to add it in an informatica client?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the different options available for update strategy?
What is the need of etl tools?
How to load a Dimension ? and how to load a fact table?
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
can we override a native sql query within informatica? How do we do it?
