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 |
what is usage of datastage with materialized views
what is 'reconsideration error' and how can i respond to this error and how to debug this
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
what is the differeces between hash and modulus partition methods
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the use of surrogate key stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the use of Row generator stage?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
Highlight the main features of datastage?
Define Routines and their types?
Differentiate between datastage and informatica?