How can you join two tables without any common column present in them?
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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the types of caches in lookup?
How to create the source and target database connections in server manager?
What is the difference between a connected look up and unconnected lookup?
What are the different ways to implement parallel processing in informatica?
which one is better performance wise joiner or look up
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of caches in lookup? Explain them.
How to handle decimal places while importing a flatfile into informatica?
Can we create a Integration service without a Repository service and vice versa?
what is unit testing?tell me proceedure
Informatica Checkpoints
How does the aggregator transformation handle null values?