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
- 3605 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What could be the possible resons of locks by user?
What do think which one is the better joiner or look up?
What is meant by LDAP users?
How do you change a non-reusable transformation to reusable transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What does command task mean?
Can we override a native sql query within informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
Which development components of informatica have the highest usage?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to differentiate between the active and passive transformations?
What is joiner transformation?
What if the source is a flat-file?
Describe an informatica powercenter?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
