how can you load data into target table without leading zeor's
- 4 Answers
- 23262 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sai
Use Exp transformation and use function
Ltrim(col_name,'0')
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
How does the aggregator transformation handle null values?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can we update a record in the target table without using update strategy?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain Dataware house architecture .how data flow from intial to end?
How are the sources and targets definitions imported in informatica designer?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the new features of informatica 9.x in developer level?
Which files are created during the session rums by informatics server?
Where are the source flat files kept before running the session?
How might you approve all mappings in the archive all the while?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the differences between source qualifier and joiner transformation?
What is meant by query override?
