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
Difference between Target-based loading and constraint-based loading?
Can you use flat files in Mapplets.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Briefly define reusable transformation?
What are the types of schemas we have in data warehouse.
How might you approve all mappings in the archive all the while?
Is it possible to use a client with different version than that of its Informatica server?
What is informatica? Why do we need it?
What do you understand by SOA of Informatica?
have u done any performance tuning? how u ll do?
Define filter transformation?
What is meant by incremental aggregation?
How to differentiate between the active and passive transformations?
What are the modules in Power Center