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 the precedence of stage variables,derivations, and constraints?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How to create environments and call them? What is the use defined variables?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
how does work server jobs?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
tell me abt Datastage trigger?
how many rows sorted in sort stage by default in server jobs
What are system variables and sequencers in datastage
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
why we use hash file for lookup?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?