Interested to Buy Any Domain ? << Click Here >> for more details...
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
- 3 Answers
- 14118 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
source contains 2 columns comes to target 4 columns how
i want job aborted after some records are loaded into output by using only sequential stage and dataset
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
What are the different plug-ins stages used in your projects?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
how can u find out the datastage job is running on how many nodes
How did you reconcile source with target?
What is ibm datastage?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Teradata 
