How to jion 2 tables, without using any condition?
Answer Posted / bittu sarkar
simply use a dummy condition like 1=1.
This works :)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
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?
Is it possible to revert a global repository to local one and why?
How can you define user defied event?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the need for an etl tool?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are junk dimensions?
What are the reusable transformations?
What is meant by lookup transformation? Explain the types of lookup transformation?
How is union transformation utilized?
what is the -ve test case in your project.
Is there any target staging area in informatica not staging area
What are the new features of informatica 9.x in developer level?
What are the different components of powercenter?