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


Please Help Members By Posting Answers For Below Questions

What is the method of removing duplicates, without the remove duplicate stage?

808


Explain datastage architecture?

1105


Differentiate between validated and Compiled in the Datastage?

956


What is datastage?

874


What a datastage macro?

865


How we can covert server job to a parallel job?

810


What is the difference between the local container and shared container?

886


What is the project in datastage?

897


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2177


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3244


What are the different kinds of views available in a datastage director?

819


What is the process of killing a job in datastage?

783


What is the difference between operational data stage (ods) and data warehouse?

1000


What is the sortmerge collector?

927


How to RD using transformer?

1144