how can you load data into target table without leading zeor's
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
What are the main issues while working with flat files as source and as targets ?
What is transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is native users?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the advantage of informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Differentiate between router and filter transformation?
What are the measure objects?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What could be the possible resons of locks by user?
What the difference is between a database, a data warehouse and a data mart?
What are the different clients of powercenter?
What is the status code in stored procedure transformation?
How you can differentiate between connected lookup and unconnected lookup?