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
- 3676 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 are active transformations.
Describe data concatenation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Briefly define a session task?
Explain the types of lookup transformation?
What are multi-group transformations?
What are junk dimensions?
What will be the approach?
how to load rows into fact table in data warehouse
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the prerequisite tasks to achieve the session partition?
What are the types of presistent cache in look up tr.
Explain lookup transformation is active in informatica
What is the session task and command task?
Is stop and abort are same in informatica?
