Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37626 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
What is workflow? What are the components of the workflow manager?
How to handle decimal places while importing a flatfile into informatica?
What is the benefit of partitioning a session?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How many number of sessions can one group in batches?
Can u generate reports in Informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What do you understand by SOA of Informatica?
can we override a native sql query within informatica? Where do we do it?
Explain the different kinds of facts.
Explain the pipeline partition with real time example?
During the running session, output files are created by informatica server. Enlist few of them.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Is it possible to use a client with different version than that of its Informatica server?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
