Interested to Buy Any Domain ? << Click Here >> for more details...
without matching columns in two tables. how can you join
- 5 Answers
- 11513 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / 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 |
Answer / ankit kansal
Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sarthak
U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.
| Is This Answer Correct ? | 1 Yes | 4 No |
Differnce between filter and router?
generate date / time dimension in informatica
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
What is a transaction control transformation?
What are connected or unconnected transformations?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
with out using update strategy transnsformation how to update the data in mapping level
what is $$$$?
What is joiner transformation in informatica?
Define pmcmd command?
What is data merging, data cleansing and sampling?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Teradata 
