what are the row and column separations in Flat Files

Answers were Sorted based on User's Feedback



what are the row and column separations in Flat Files..

Answer / subu

For row separation genrally new line is used.
For column separation generally ',' , '|' are used.

Is This Answer Correct ?    11 Yes 0 No

what are the row and column separations in Flat Files..

Answer / kittu

I think that is delimiters

Is This Answer Correct ?    1 Yes 0 No

what are the row and column separations in Flat Files..

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

Post New Answer

More Informatica Interview Questions

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


What are the active and passive transforamtions?

2 Answers  


My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,






Differences between connected and unconnected lookup?

0 Answers  


how to use incremental load?

2 Answers   TCS,


How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


What are the various types of transformation?

0 Answers  


what is mean by complex business rule ?

0 Answers   Cap Gemini,


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

3 Answers  


in which situations do u go for snowflake schema ?

2 Answers   TCS,


Categories