How to jion 2 tables, without using any condition?
Answer Posted / raj
Add dummy column in expression or Source Qul. for both
source and use that column in join condition.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is meant by target load plan?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
According to his methodology what all you need before you build a datawarehouse
To import the flat file definition into the designer where should the flat file be placed?
Explain dynamic target flat file name generation in informatica
Global and Local shortcuts. Advantages.
What is the need for an etl tool?
What are the uses of etl tools?
Quickly characterize reusable change?
How can we use mapping variables in informatica? Where do we use them?
What are the types of schemas we have in data warehouse.
can we override a native sql query within informatica? Where do we do it?
In informatica workflow manager, how many repositories can be created?
State the differences between sql override and lookup override?