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.
Answer Posted / rakesh
no my question is clear. and my target is oracle table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What all are steps in up gradation of Informatica server?
How we can create indexes after completing the load process?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the scenario which compels informatica server to reject files?
difference between informatica 8.1.1 and 8.6
What are the designer tools for creating transformations?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Write the program through which the records can be updated?
What is intricate mapping?
How do you load only null records into target?
What is workflow? What are the components of the workflow manager?