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 |
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
What are the active and passive transforamtions?
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
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Differences between connected and unconnected lookup?
how to use incremental load?
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?
What are the various types of transformation?
what is mean by complex business rule ?
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
in which situations do u go for snowflake schema ?