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
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the function of look up transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is an Integration service in Informatica?
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?
What does “tail –f” command do and what is its use as an Informatica admin.
difference between repository database and repository service?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is blocking transformation?
What are the settings that you use to configure the joiner transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the limitations of joiner transformation?
Separate from a database, an information bazaar, and an information stockroom?
What is exclusive and normal mode for repository services?