Interested to Buy Any Domain ? << Click Here >> for more details...
how can we extract data with out having any common column
- 7 Answers
- 17609 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
What are routines in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the difference between account and directory options ?
what is ds administrator used for?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is orabulk stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain connectivity between datastage with datasources?
What is oci?
What is the different type of jobs in datastage?
How to clean the datastage repository?
Is the value of staging variable stored temporarily or permanently?
Differentiate between data file and descriptor file?
