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

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,


What are the various kinds of the hash file?

0 Answers  


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  


What is the difference between account and directory options ?

0 Answers  


What are the components of datastage?

0 Answers  






what is materialized view used datastage?

1 Answers   HSBC,


Describe link sort?

0 Answers  


I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,


1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,


when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,


What is lookup table?

5 Answers  


I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  


Categories