Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 38058 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / kalyan
In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:
Select * from emp,dept;
The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
How many ways are there to do 'remove duplicate records in informatica'?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are ETL Tools?
Which is the t/r that builts only single cache memory?
scenario where i can use only concurrent execution of workflow.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
design of staging area?
What are the reusable transformations?
How many types of sessions are there in informatica.please explain them?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain why we use partitioning the session in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is workflow manager?
What is the use of code page?
