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 |
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What are partitions in informatica and which one is used for better performance?
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?
is it possible to index the data in cache of lkp transformation ?
What is exclusive and normal mode for repository services?
What are the rank caches?
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.
What is the Process to creating lookup transformation in 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
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?
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?