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 are the benefits of datastage?
How to clean the datastage repository?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Can you highlight the main features of ibm infosphere information server?
What is difference between server jobs & parallel jobs?
What is job control?
What are the job parameters?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
whom do you report?
What are the steps needed to create a simple basic datastage job?
What is the difference between an operational datastage and a data warehouse?
What are the differences between datastage and informatica?
What are the types of hashed files in data stage
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.