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
- 9723 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / guest
Your question seems need some correction.
Source might be as below
eno, ename, sal
111, sri ram kumar, 1000
and target you might need like a space delimited one. If
this is the case you can sed command to replace the string.
if your file is as mentioned by you also it will be same.
If my understanding is wrond then eleborate your question
clearly.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Why update strategy and union transformations are active? Explain with examples.
Define update strategy?
To import the flat file definition into the designer where should the flat file be placed?
Is it possible to use a client with different version than that of its Informatica server?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is flashback table ? Advance thanks
What are the different versions of informatica?
In warehouses how many schemas are there?
How do we call shell scripts from informatica?
What is an aggregator transformation?
What is the need for an etl tool?
What is Cognos script editor?
What are session parameters ? How do you set them?
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
