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
- 12678 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
Describe link sort?
How can you write parallel routines in datastage PX?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is a datastage job?
What are the benefits of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain ibm infosphere information server and highlight its main features?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is a folder? Difference types of stages?
Differentiate between odbc and drs stage?
What is job control?
What is size of a transaction and an array means in a datastage?
On which Dimension Table you implemented SCD Type in your Project
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
