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
What all the types of jobs you developed?
How many types of sorting methods are available in datastage?
how to sort two columns in single job in datastage.
How many areas for files does datastage have?
Differentiate between validated and Compiled in the Datastage?
how to write server Routine coding?
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)
Where do the datastage jobs get stored?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the areas of application?
what is use of SDR function?
How do you schedule or monitoring the job?
Distinguish between informatica & datastage. Which one would you choose and why?
Explain how a source file is populated?