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.

Answers were Sorted based on User's Feedback



my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my targ..

Answer / rajesh kumar

see while we load into source analyser as considerd as cama
separated it shows us 5 columns
now we should replace the 'cama' with null
use s->s/q-->expre-->target
give additional outputport as ename
exp condition=column2||''||column3||''||column3

Is This Answer Correct ?    6 Yes 1 No

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my targ..

Answer / ahalya inturi

Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.

Is This Answer Correct ?    2 Yes 1 No

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my targ..

Answer / rakesh

no my question is clear. and my target is oracle table.

Is This Answer Correct ?    0 Yes 0 No

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my targ..

Answer / 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

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my targ..

Answer / 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

More Informatica Interview Questions

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  


What is the maplet?

0 Answers   Informatica,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


What is the command used to run a batch?

0 Answers  






What are the join types in joiner transformation?

1 Answers   Informatica,


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


What are the uses of a Parameter file?

3 Answers   CSC,


what are cost based and rule based approaches and what is the difference?

1 Answers  


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


In session log thier should not be a single error how will u do

3 Answers   HCL,


How Union Transformation is an Active Trans?

6 Answers  


Categories