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
- 3813 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 |
What are the different etl testing categories as per their function?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what are the data modeling tools you have used?(polaris)
Explain about the data integration suite features?
what happens if the info.server doesn't find the session parameter in the parameter file?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
how many steps are there in etl process?
how do u implement unconn.stored proc. in a mapping?
how do u really know that paging to disk is happening while u are using a lookup transform?
how do u implement configuration management in Informatica?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is data cleaning?
Teradata 
