IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
Answers were Sorted based on User's Feedback
Answer / arshad basha
Initially we cannot use the dataset as a source.cause it is an internal format creation of datastage. if the source file is in the format of flat file means then we select sequential file as a source and dataset as a target.After this creation we use the target as a source for the next step. .ds is the file extension of dataset.
Is This Answer Correct ? | 27 Yes | 0 No |
Answer / dilip anand k.
Nope. Dataset can never be used as a primary source or a
final target. It can be used only as an intermediate storage
or intermediate source and a target. This is because,
Dataset is something that is proprietary to Data stage and
is understandable only to Data stage engine and none other.
Is This Answer Correct ? | 4 Yes | 6 No |
What is the difference between validate and compile?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
What is the importance of the exception activity in datastage?
Explain briefly scd type2 in datastage7.5x2(parallel)
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
What is the difference b/w Hash file and Lookup Fileset stages?
How to RD using transformer?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
how do you pass parameters in a script?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????