Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join two tables without any common column present in them?
- 1 Answers
- 3698 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Write the different tools in the workflow manager?
Which is the t/r that builts only single cache memory?
What is sq transformation?
How are indexes created after completing the load process?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
How to extract original records at one target & Duplicate records at one target?
How to do unit testing in informatica? How to load data in informatica ?
What are the guidelines to be followed while using union transformation?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
how do u fnd the duplicate rows and how to delete the duplicate rows?
How can we integrate different flat file data in a single mapping and with in a single execution
Which files are created during the session rums by informatics server?
Teradata 
