without matching columns in two tables. how can you join
Answer Posted / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
Explain scd type 3 through mapping.
How many ways are there to create ports?
How do you load first and last records into target table?
Explain the different kinds of facts.
What are the components of the workflow manager?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is sq transformation?
What is the benefit of session partitioning?
Explain your project of banking domian.
Explain the shared cache and re-cache?
What is domain in terms of informatica?
How do you take back up of repository?
Differences between version 7.x and 8.x.