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 |
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
what is the gap analysis?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
what is the need of session partitioning... how it is useful in real time
How to handle decimal places while importing a flatfile into informatica?
Describe data concatenation?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
Is stop and abort are same in informatica?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
who is the best faculty for informatica in hyderabad ameerpet?
What is joiner change?