what are the row and column separations in Flat Files
Answers were Sorted based on User's Feedback
Answer / subu
For row separation genrally new line is used.
For column separation generally ',' , '|' are used.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / vemuri vijay
steps
go to
1.source anlyzer
import from files
then attach your
file
then
select tick the option
import field names from first line
| Is This Answer Correct ? | 0 Yes | 10 No |
What is difference between stored procedure transformation and external procedure transformation?
Can we combine a flatfile and a database table using an UNION transformation?
major difference between normal loading and bulk loading?
Define filter transformation?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Explain the types of lookup transformation?
Whats there in global repository
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is data driven?
how to sort date field in infomatica?
How to send duplicates to one target and unique rows to one target?target is empty
What is degenerated dimention table?