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
- 13106 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
what is the use of skid in reporting?
What a datastage macro?
What is the difference between an operational datastage and a data warehouse?
What is difference between join, merge and lookup stage?
What is the use of datastage director?
Explain the importance of surrogate key in data warehousing?
Can you define merge?
What are the main features of datastage?
What are the types of containers and how to create them?
Can you implement SCD2 using join, transformer and funnel stage?
What is size of a transaction and an array means in a datastage?
What are the types of views in datastage director?
How a routine is called in datastage job?
In Datastage, how you can fix the truncated data error?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
