what are the row and column separations in Flat Files

Answer Posted / subu

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

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Clarify the utilization of aggregator cache record?

578


Explain the features of connected and unconnected lookup.

548


How can we handle two sessions in informatica?

616


What is substr in informatica?

665


What are the static cache and dynamic cache in informatica?

720






COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1537


Which are the different editions of informatica powercenter that are available?

559


Under which circumstances, informatica server creates reject files?

593


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What is mapplet in informatica?

598


What is the benefit of session partitioning?

600


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?

5585


What is sequence generator transformation in informatica?

625


How many number of sessions can one group in batches?

696


what is the Default Source Option For Update Strategy Transformation?

759