how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 14560 Views
- I also Faced
- E-Mail Answers
Answer Posted / k bhavani durga
this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.
it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how to connect to a flatfile through ftp in informatica
Explain the key challenges that you face while performing etl testing.
When do we analyze the tables?
Explain about the data integration suite features?
How many steps etl contains?
where is the cache (lookup, index) created and how can you see it.
what is the difference between cubes and package in cognos
Compare ETL & Manual development?
What are snapshots?
What are the ETL Testing Operations?
Is apache nifi an etl tool?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Give the benefits of data integration suite?
Explain the use lookup tables and Aggregate tables?
