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
- 9734 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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Enlist few areas or real-time situations where informatica is required.
Mention a few design and development best practices for informatica?
How to call shell scripts from informatica?
Briefly define a session task?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the popular informatica products?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the scenario which compels informatica server to reject files?
What is depict expression change?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Differences between connected and unconnected lookup?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Could you explain what is enterprise data warehouse?
How can you increase the performance in joiner transformation?
