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
- 2869 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kvikas2056
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what are the concerns of OLTP and DSS systems?
how to connect to a flatfile through ftp in informatica
What are the key benefits of ETL Testing?
can cubes contain measures ?
how do u set partition points in the mapping?
what is the use of server?
what do u do when DB time takes more?in sap bi
What are various etl tools in the market?
what is data modeling?
what is Forward,Reverse and Re_engineering?
What is a mapping, session, worklet, workflow, mapplet?
how would u estimate the size of Aggregator transform data and index cache?
how does the server recongnise the source and target databases.Elaborate on this
What is lookup table in etl testing?
