Interested to Buy Any Domain ? << Click Here >> for more details...
How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica
- 1 Answers
- 6048 Views
- I also Faced
- E-Mail Answers
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 |
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
What is the role of informatica in project ?Like i showed financial projects?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is mapplet in informatica?
What is different between the data warehouse and data mart?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is the difference between Active and Passive transformation?
write a query to get maximum salary from the employers table without duplicates....kindly help me
What is the need of etl tools?
What is the maplet?
Teradata 
