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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Does an informatica transformation support only aggregate expressions?
What are the types of schemas we have in data warehouse and what are the difference between them?
Where are the source flat files kept before running the session?
explain abt ur project architecture?
How to differentiate between the active and passive transformations?
Explain Dataware house architecture .how data flow from intial to end?
Explain scd type 3 through mapping.
pmscmd startworkflow -sv
wat are deployement groups in informatica, how it will be used for developers
What are the issues you have faced in your project? How did you overcome those issues?
What is complex mapping?
Why update strategy and union transformations are active? Explain with examples.
EXL informatica Questions
permutations of mapplet