how can we extract data with out having any common column
Answers were Sorted based on User's Feedback
Answer / ram
Question not clear. can u check your question.
i think you want to know how to extract data from 2 tables
which doesnt have a common column.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / siri
Hi,
If meta data is same u can achieve this in 2 ways.
1) In job properties -> before job subroutine -> cp file1.txt file2.txt
2) Use Funnel
Meta data is not same then you need key.(With out key it is not possible)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sridhar
Use lookup stage .this scenario u will do through lookup
stage .But whatevr You joining columns datatype must be
same.cOrrect me if i am wrong
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / nagakalyan
by using transformer we can but the joining two tables at
least have same datatype and data
Is This Answer Correct ? | 0 Yes | 4 No |
Give an idea of system variables.
How to read the length of word in unix?
What is the difference between odbc and drs stage?
Where do you see different stages in the designer?
How do you import and export data into datastage?
why dataset ?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
job locking methods? How can we unlock the job?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Differentiate between hash file and sequential file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?