it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
Answer Posted / amit
Two tables means, there is a possibility of mismatching metadata. In this case also, we can load data into a sequential file without maintaining the metadata of two tables.
If we want to keep track of these records, then we can, add one record identifier field, to later identify the records while extracting data from file.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between hash file and sequential file?
What are the various kinds of containers available in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is a quality stage in datastage tool?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the functionalities of link collector?
What are the areas of application?
Can you filter data in hashed file?
What is the difference between hashfile and sequential file?
Define ds designer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Enlist various types of routines in datastage.
what is flow of project?