Interested to Buy Any Domain ? << Click Here >> for more details...
it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
- 6 Answers
- 12640 Views
- TCS, I also Faced
- E-Mail Answers
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 is a merge in datastage?
table actions available in oracle connector?
What is the difference between the local container and shared container?
Notification Activity
how to implement scd2 in datastage 7.5 with lookup stage
What is the different type of jobs in datastage?
Explain ibm infosphere information server and highlight its main features?
What is the difference between odbc and drs stage?
What is the purpose of pivot stage and types of containers in datastage
How many types of views are there in a datastage director?
What are the functionalities of link partitioner?
What is the difference between informatica and datastage?
How do you reject records in a transformer?
What is aggtorec restructure operator?
Have you have ever worked in unix environment and why it is useful in datastage?
