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
- 9730 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Go to session --> Mapping tab --> click on your target file --> Select File Properties (from the file properties in the right)
This will open the file properties window, click on the advanced button and in the next popup you should be able to see the delimiter option in the top. You can now replace the delimiter you want with the existing one.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Define Pmrep command?
What is a router transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is fact table? Explain the different kinds of facts.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is $$$$?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between informatica 7.0 and 8.0?
What are the different options available for update strategy?
Why update strategy and union transformations are active? Explain with examples.
What is meant by active and passive transformation?
what is the size of u r source(like file or table)?
