Interested to Buy Any Domain ? << Click Here >> for more details...
how can we extract data with out having any common column
- 7 Answers
- 17358 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
If you want to use a same piece of code in different jobs, how will you achieve this?
how do u catch bad rows from OCI stage? And what CLI stands for?
How to perform incremental load in datastage?
What is meta stage?
How will you move hashed file from one location to another location?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Nls stands for what in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is "fatal error/rdbms code 3996" error?
Can you explain engine tier in information server?
What are the components of datastage?
Does datastage support slowly changing dimensions ?
