Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?
- 5 Answers
- 13426 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bob
Repacechr(1,""TCS"MUMBAI",'"',null)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is repository manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In development project what is the process to follow for an etl developer from day1
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the use of an aggregator cache file?
How many types of sessions are there in informatica.please explain them?
Can we get 1st record through Informatica(without sequence number).
What is union transformation in informatica?
What is sequence generator transformation in informatica?
How to create or import flat file definition in to the warehouse designer?
Where is metadata stored?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the status code in stored procedure transformation?
