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 |
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
What is a range lookup?
What is difference between server jobs & parallel jobs?
Difference in the implementation of lookup and join stages,in joining two tables?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Is possible to create skid in dim,fact tables?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
how to unlock a locked job in datastage 8.0
root tree will find which is server job and which is parallel job?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage