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 are the areas of application?

0 Answers  

how can we do null handling in sequential files

2 Answers   Reliance,

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

what is hash file

2 Answers   CTS, IBM,

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

How to manage date conversion in Datastage?

0 Answers  

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,