Answer / 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.

Answer / venugopal

Yes you can join two tables and load the data into
sequential file...
Take two tables use join stage and join the data based on
the key and then load the data into sequential file...

Answer / amit

Two tables means, there is a possibility of mismatching metadata. In this case also, we can load data into a sequential file without maintaining the metadata of two tables.

If we want to keep track of these records, then we can, add one record identifier field, to later identify the records while extracting data from file.

Answer / raja sekhar

yes,possible first jest give the path name of the one of the
table in stage tab then go to the output tab then u can find
out the load option jest load the one table data.through the
load option u can load the second table also.

Answer / 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.

Answer / ramesh

sequential file has no storage memory limit. so that
possible.but hashed file is not possible.

what is time dimension? and how to populate time demension

2 Answers   TCS,

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

what is a nodemap constraint

2 Answers   IBM,

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

why we use parameters instead of hard code in datastage

4 Answers   HCL,

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

how to convert rows into columns

2 Answers   IBM,

What are the components of ascential data stage?

0 Answers  

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,