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?
Answer Posted / chow
we can do using ltrim and rtrim and concat two words
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What do you mean by filter transformation?
tell me the rules and responsblites in our project(my project is development)
draw informatica architecture 8.6 ?
is it possible to index the data in cache of lkp transformation ?
What are the different types of repositories created using informatica?
What is mapplet in informatica?
What is an active transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the cumulative sum and moving sum?
what is the difference between informatica6.1 and infomatica7.1
Clarify the utilization of aggregator cache record?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Do you find any difficulty while working with flat files as source and target?