Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37725 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / jaimeen shah
it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.
if u use two different database source then use joiner to
join the two tables.
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
Different sorts of metadata that stores in the storage facility?
Which development components of informatica have the highest usage?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Define joiner transformation?
How do you promote a non-reusable transformation to reusable transformation?
Write the program through which the records can be updated?
What are the data movement modes in informatica?
Difference between Target-based loading and constraint-based loading?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is an Integration service in Informatica?
Why update strategy and union transformations are active?
How many transformations can be used in mapplets.
What is aggregate cache in aggregator transformation?
Is it possible to use a client with different version than that of its Informatica server?
