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
- 11993 Views
- TCS, I also Faced
- E-Mail Answers
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
Why union transformation is an active transformation?
What is repository manager?
how to create user defined function (udf) in informatica
what is INFORMATICA TESTING process
whats the logic to load the lower level of granularity of data to fact table.
Explain the difference between a data warehouse and a data mart?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
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?
is it possible to index the data in cache of lkp transformation ?
what is mean by complex business rule ?
What are the new features of informatica 9.x in developer level?
Explain scd type 3 through mapping.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain why we use partitioning the session in informatica?
