source which format u will get either fixed or delimiter
length format? what is the symbol of delimiter?
Answer Posted / 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 View All Answers
Triggers,VIEW,Procedures
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how many rows sorted in sort stage by default in server jobs
Can we use target hash file as a lookup ?
what are the errors,warnings in datastage
Why do we use link partitioner and link collector in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Whats difference betweeen operational data stage (ods) and data warehouse?
Name the different sorting methods in datastage.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is difference between server jobs & parallel jobs?
Could anyone give brief explanation bout datastage admin
Differentiate between validated and Compiled in the Datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.