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
- 9650 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 create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What do think which one is the better joiner or look up?
what is $$$$?
Plz can any one say me how to get the informatica certification materials and dumps
How can one identify whether mapping is correct or not without connecting session?
-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?
expain about the tune parameters?
What do you mean incremental aggregation?
Describe data concatenation?
What is the reusable transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Do you find any difficulty while working with flat files as source and target?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How many numbers of sessions can one group in batches?
