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
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 |
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 |
Difference between sequential file and data set?
Explain usage analysis in datastage?
What are datastage sequences?
Define meta stage?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
Why we use surrogate key?
How to find value from a column in a dataset?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What are some different alternative commands associated with "dsjob"?
how to find diff between 2 dates without using Icon... funtions?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this