my source is a comma delimited flatfile as
eno, ename, sal
111,sri,ram,kumar,1000
and my target should be
eno ename sal
111 sri ram kumar 1000
i.e; we need to eliminate the commas in between the data of a comma delimited file.
Answer Posted / rakesh
no my question is clear. and my target is oracle table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Tell me about Propagate functions in informatica
How to extract sap data using informatica?
Explain sessions?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How can we create index after completion of load process?
Explain dynamic target flat file name generation in informatica
How do we call shell scripts from informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Mention some types of transformation?
What is a node in Informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
scenario where i can use only concurrent execution of workflow.
Please let me know how to make Data masking in informatica..
How can you increase the performance in joiner transformation?
Make a note of the quantity vaults made in informatica?