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
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What if the source is a flat-file?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are mapplets? How is it different from a Reusable Transformation?
How we can create indexes after completing the load process?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the maplet?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain in detail scd type 2 through mapping.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to generate sequence numbers using expression transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the function of aggregator transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you