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
- 3709 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 is a grid in Informatica?
What is the need for an etl tool?
Define the various join types of joiner transformation?
Why is sorter an active transformation?
tell me the rules and responsblites in our project(my project is development)
Briefly define a session task?
How to join three sources using joiner?
How to start a workflow using pmcmd command?
Explain about Informatica server process that how it works relates to mapping variables?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the databases that informatica can connect to windows?
How does a sorter cache works?
What do you mean incremental aggregation?
Explain why we use partitioning the session in informatica?
What are the data movement modes in informatica?
