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
- 9334 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinav prakash
Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is sorter transformation?
What are the modules in Power Center
Explain lookup transformation in informatica
Explain incremental aggregation in informatica
What are the tasks that can be performed using sq?
What will be the approach?
What is fact table? Explain the different kinds of facts.
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?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Write the program through which the records can be updated?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
where to store informatica rejected data? How to extract the informatica rejected data?
How to configure mapping in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
