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 |
How will u pas the data with out debugger?
Tell me about Propagate functions in informatica
What is the reusable transformation?
What are the rank caches?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how to run 2 workflows sequentially. plz respond what is the process?
Differentiate between mapping parameter and mapping variable?
What is the surrogate key?
What are the different threads in DTM process?
What are active transformations.
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How