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 ‘|’ .
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 partition the Session?
How do you load unique records into one target table and duplicate records into a different target table?
What is sorter transformation?
What is enterprise data warehousing?
Explain the different dimensions.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the main issues while working with flat files as source and as targets ?
How can you validate all mappings in the repository simultaneously?
Quickly characterize reusable change?
What is InformaticaPowerCenter?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is the hint? how to use it to reduce the query processing in program?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are batches?
How to update or delete the rows in a target, which do not have key fields?