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 data partitioning?

938


how can we create rank using datastage?what is the meaning of rank?

8449


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

1893


Can you implement SCD2 using join, transformer and funnel stage?

1325


What are some different alternative commands associated with "dsjob"?

896


How do you reject records in a transformer?

858


what are the errors,warnings in datastage

2400


What are the types of views in datastage director?

1538


how to abort the job its matain duplicates?

2341


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

2155


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1978


Can you define merge?

881


Which algorithm you used for your hashfile?

905


what is the custome stage in datastage? how can we impliment that one? plz tell me

2149


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

899