source which format u will get either fixed or delimiter
length format? what is the symbol of delimiter?
- 2 Answers
- 5865 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to RD using transformer?
What is the difference between account and directory options ?
whats difference between ls -ltr and ls -lrt?
what is the diff b/w switch and filter stage in datastage
what is combinability and non combinability?
What is apt_config in datastage?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
Unix command to view the data in a dataset
what is meta data? Explain? Where it is used?
Teradata 
