How can you join two tables without any common column present in them?

Question Posted / lisa

1 Answers
2922 Views
TCS, I also Faced
E-Mail Answers

How can you join two tables without any common column present in them?..

Answer / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers TCS,

What is informatica metadata and where is it stored?

0 Answers

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers TCS,

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers

My source table having some records ,i want load 1st record and last record into one target?

3 Answers iGate,

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers

What are the different transaction levels available in transaction control transformation?

0 Answers Informatica,

What is the need of an ETL tool?

0 Answers Informatica,

In informatics server which files are created during the session rums?