how can we extract data with out having any common column

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Question Posted / pavan_adit

7 Answers
17081 Views
IBM, Switch2iTech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we extract data with out having any common column..

Answer / vijay

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

Is This Answer Correct ?

13 Yes

2 No

how can we extract data with out having any common column..

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

how can we extract data with out having any common column..

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

how can we extract data with out having any common column..

Answer / raj

yes. PLZ give me the ans

Is This Answer Correct ?

0 Yes

0 No

how can we extract data with out having any common column..

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

how can we extract data with out having any common column..

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

how can we extract data with out having any common column..

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

Post New Answer