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
- 9894 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
Differences between version 7.x and 8.x.
How big was your fact table
Mention a few design and development best practices for informatica?
Where is metadata stored?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the performance considerations when working with aggregator transformation?
Quickly characterize reusable change?
What is the need of etl tools?
Briefly explain the aggregator transformation?
What are the types of presistent cache in look up tr.
What is an Integration service in Informatica?
What is the advantage of informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is olap (on-line analytical processing?
