How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica
- 1 Answers
- 5321 Views
- I also Faced
- E-Mail Answers
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
Explain pushdown optimization and types in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a standalone command task?
Mention few advantages of router transformation over filter transformation.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can u any challenge your project?
How do you handle two sessions in Informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how to create user defined function (udf) in informatica
Explain how many types of dimensions are available in informatica?
How can one identify whether mapping is correct or not without connecting session?
What is a code page?
Explain the use of aggregator cache file?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to create a non-reusable instance of reusable transformations?
