it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
Answer Posted / srikanth reddy m
If the two tables having same key column, then based on that key column we can able join the two tables. This is nothing but horizantal joining.
or
If the the two tables having same metadata, then using funnel stage we can perform vertical joining. whether it may continuous or sequence funnel.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name the different sorting methods in datastage.
What are the types of containers?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the stages in datastage?
To see hidden files in LINIX?
client know skid info?
Can you explain tagbatch restructure operator?
What is merge stage?
root tree will find which is server job and which is parallel job?
What is size of a transaction and an array means in a datastage?
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.
What a datastage macro?
Define project in datastage?
How you can fix the truncated data error in datastage?
What is the purpose of interprocessor stage in server jobs?