when we have to go for a sequential file stage & for a
dataset in datastage?
Answer / srinu
when the memory limit requirement is more then we go for
dataset.because sequential file does not support more than
2gb memory limit
| Is This Answer Correct ? | 2 Yes | 0 No |
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is the default padding character?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
how CAN we remove duplicates in dataset?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
Give an idea of system variables.
Different ways a project can be moved to production ?...example ….export-import and Version control.
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
What is the differentiate between data file and descriptor file?
How can u write exception handling in seq file????
Explain usage analysis in datastage?
How do you run datastage job from the command line?