how can we extract data with out having any common column
- 7 Answers
- 14967 Views
- IBM, Switch2iTech, I also Faced
- E-Mail Answers
Answer Posted / bietl
Hi,
it's just simple as this..
Suppose we have two tables T1 and T2.
Now load the two tables to Seq.files as S1 and S2.
T1............ S1
T2............. S2
Now S1 and S2 are our two seq.files load the two files data
by selecting the S2 seq.file option as append then we will
get the S1 and S2 data as same as T1 and T2.
I hope it will clarify ur question
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
in oracle target stage when we use load option and when we use upsert option?
EXPLAIN SCD
What are the functionalities of link collector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain usage analysis in datastage?
What is the flow of loading data into fact & dimensional tables?
Is the value of staging variable stored temporarily or permanently?
What is the difference between validated and compiled in the datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between odbc and drs stage?
What is data partitioning?
What could be a data source system?
Where do you see different stages in the designer?
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?
Triggers,VIEW,Procedures
