How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica
Answer Posted / 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 View All Answers
Please let me know how to make encryption and decryption with example?
How you prepared reports for OLAP?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain what are the different types of transformation available in informatica.
What is informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain the different dimensions.
Explain lookup transformation in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is joiner transformation?
What is joiner transformation in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are session parameters ? How do you set them?
How can we use mapping variables in informatica?
What is workflow manager?