how can we extract data with out having any common column
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 is merge stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between data file and descriptor file?
What are the types of hashed files in data stage
Why we use surrogate key?
Lookup constraints
What are the various kinds of the hash file?
What is ibm datastage?
In Datastage, how you can fix the truncated data error?
Give an idea of system variables.
What are the types of jobs we have in datastage?
Which commands are used to import and export the datastage jobs?
How a routine is called in datastage job?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?