How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica



How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica..

Answer / pavana

HI

In file properties set the optional quotes to either single
or double quotes. It considers the data b/w two Quotes as
the data for a single column .However the columns must be
separated by comma

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


whatis the default data driven operation in informatica

2 Answers  


What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  


What aer the out put files that the informatica server creates during the session running?

4 Answers  






what is target load plan

2 Answers   Cap Gemini,


Can we create out put ports in source qualifier t/r?

5 Answers   TCS,


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

3 Answers   Infotech,


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


diffrence between command task and control task

1 Answers   iNautix,


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


Categories