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 |
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
What is the use of an aggregator cache file?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What is a repository manager?
SO many times i saw "$PM parser error " .what is meant by PM?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
scd methodology?
explan ur project architecture?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
in which situations do u go for scds ?
who is the best faculty for informatica in hyderabad ameerpet?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.