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
- 9327 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
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain the different lookup methods used in informatica?
What is an Integration service in Informatica?
What are the different components of powercenter?
What are the various types of transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of caches in lookup? Explain them.
Differentiate between Load Manager and DTM?
How many ways are there to do 'remove duplicate records in informatica'?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the use of transformation?
how many types of dimensions are available in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
have u done any performance tuning? how u ll do?
Explain the difference between a data warehouse and a data mart?
