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
- 12632 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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...
| Is This Answer Correct ? | 8 Yes | 1 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do u convert the columns to rows in datastage?
How a source file is populated?
What are the types of jobs we have in datastage?
how do u reduce warnings
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is a range lookup?
Teradata 
