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

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


What are partitions in informatica and which one is used for better performance?

2 Answers  


what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,


What is the default join that source qualifier provides?

3 Answers   Informatica,


is it possible to index the data in cache of lkp transformation ?

0 Answers  






What is exclusive and normal mode for repository services?

0 Answers  


What are the rank caches?

2 Answers   Informatica,


hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,


What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Categories