how can we extract data with out having any common column

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

More Data Stage Interview Questions

how to add a new records into source?

0 Answers  


Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,


I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,


Differentiate between odbc and drs stage?

0 Answers  






How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  


how to find out number of records imported into source file?

1 Answers  


why we use hash file for lookup?

5 Answers  


How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  


Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  


What is the differentiate between data file and descriptor file?

0 Answers  


Differentiate between hash file and sequential file?

0 Answers  


Categories