source which format u will get either fixed or delimiter
length format? what is the symbol of delimiter?

Answers were Sorted based on User's Feedback



source which format u will get either fixed or delimiter length format? what is the symbol of delim..

Answer / srinivas

Hi,
If the source is file then the records is separated by
either fixed length or delimiter format. and the symbol of
delimiter means any some special character separate the records
EG:Delimiter
Eid,Ename,Sal
1,aaa,2000
2,bbb,3000

EG:FixedLength
Eid Ename Sal
1 aaa 1000
2 bbb 2000

Is This Answer Correct ?    6 Yes 0 No

source which format u will get either fixed or delimiter length format? what is the symbol of delim..

Answer / david

source file can be 
1.delimeter file
2.fixed width file

if delimeter files delimeters will be like this
eg:  ,  | @ # * space null  /

for fixed width files 
eg: fixed length no delimeter bw the records

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

what is hash file

2 Answers   CTS, IBM,


30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  


Pls tell me what is troubleshooting in datastage view?

1 Answers  


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


table actions available in oracle connector?

0 Answers   CTS,


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,


tell me abt Datastage trigger?

1 Answers   HP, IBM,


In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  


Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,


which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,


if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,


What is the difference between informatica and datastage?

0 Answers  


Categories