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 |
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
What modeling tool do you use?
What are stage variables?
How many jobs in ur project? Explain any complex job u have done in ur project?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
how can or from where we can get reference data in scd type2 implementation?
Can you explain repository tables in datastage?
What is diff between Junk dimensions and conform dimension?
What are the different common services in datastage?