Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
- 2 Answers
- 3654 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database
| Is This Answer Correct ? | 1 Yes | 0 No |
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What are cubes and olap cubes?
how do u implement unconn.stored proc. in a mapping?
Give the benefits of data integration suite?
what happens if the info.server doesn't find the session parameter in the parameter file?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is data modeling?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Identifying the bottlenecks in various components of Informatica and resolving them.
Teradata 
