Answer Posted / pushpendra
replacechr function can use.
replacechr(0,Column_Name,' ','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
Briefly explain the aggregator transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
waht type of interface is used for testing the data in informatica
How many transformations can be used in mapplets.
What is the need of an ETL tool?
What is InformaticaPowerCenter?
What are the new features of informatica 9.x developer?
I have a flat file, want to reverse the contents of the flat file
complex mapping ur project u r invlve can u explain and give real time example give me ?
What do you mean by enterprise data warehousing?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are mapplets?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.