Interested to Buy Any Domain ? << Click Here >> for more details...
how can we extract data with out having any common column
- 7 Answers
- 17178 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
EXPLAIN SCD
If you want to use a same piece of code in different jobs, how will you achieve this?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the important features of datastage?
How to perform incremental load in datastage?
Differentiate between Join, Merge and Lookup 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.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to read multiple files using a single datastage job if files have the same metadata?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the different type of jobs in datastage?
What are sequencers?
Why do you need stage variables?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between orabulk and bcp stages?
