Interested to Buy Any Domain ? << Click Here >> for more details...
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
- 3 Answers
- 14072 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 |
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
What is Fastly Changing Dimension?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How a routine is called in datastage job?
which memory is used by lookup and join
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
where the log files or tables can store in DS?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How a source file is populated?
Teradata 
