it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
Answer Posted / subhash
Lets discuss diff cases:
1. If the two tables having same key column,
then based on that key column we can able join the two
tables. It's horizantal joining.
Ex: Table1 has 10 columns +1Key col
Table2 has 5 columns +1Key col
in target SeqFile we get 10+5+1 columns
2. If the two tables having same metadata,
Then using funnel stage we can perform vertical joining.
whether it may continuous or sequence funnel.
In this case we can add extra columns 'INDICATOR'(1 for
Table1 and 2 for Table2 records in the select query) to
identify records
3. If the two tables not having same metadata & Key column,
We can generate 1 common Key column from Column Generator
Stage- 'DUMMY'(values: 1,2,3,4,...) for 2 tables
Then, we can join based on DUMMY column to get all the
columns from the both tables and load those columns to
SeqFile.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What all are the different way to run a job?
How a server job can be converted to a parallel job?
What is the purpose of interprocessor stage in server jobs?
What is the difference between in process and inter process?
What is the differentiate between data file and descriptor file?
Why do we use link partitioner and link collector in datastage?
What are the differences between datastage and informatica?
What are the stages in datastage?
What is the command line function to import and export the ds jobs?
How do you generate sequence number in datastage?
EXPLAIN SCD
What is the difference between datastage and datastage tx?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
what is repositery?
Can you filter data in hashed file?