Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 9743 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ahalya inturi
Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why do we need informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the maplet?
What is a snowflake schema?
Explain pushdown optimization and types in informatica
What does update strategy mean, and what are the different option of it?
What are the differences between joiner transformation and source qualifier transformation?
What are the features of complex mapping?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the different transaction levels available in transaction control transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Differentiate between source qualifier and filter transformation?
Explain the different kinds of facts.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we change Dynamic to Static or Persistent cache? If so what happens?
