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 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
What is the different lookup cache(s)?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What all are steps in up gradation of Informatica server?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What is the benefit of partitioning a session?
can session assigned multiple mappings or not?
what is the gap analysis?
what is incremental aggregation ,with example?
can you please explain me pre session and post session options?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c