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
- 13446 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
Why do you use Mapping Parameter and mapping variable?
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 if the source is a flat-file?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is Data Caches size?
Define filter transformation?
Differentiate between Load Manager and DTM?
How we can create indexes after completing the load process?
How are the sources and targets definitions imported in informatica designer?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to implement security measures using repository manager?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain pushdown optimization and types in informatica
How do you promote a non-reusable transformation to reusable transformation?
Explain Dataware house architecture .how data flow from intial to end?
