I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
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
what is session partitioning?
how do use session mapping parameters ?(in which transformation)
what are the session parameters? How do u set them?
what is dynamic insert?
What is etl process?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
tell me few points when u become TL
Difference between flat files and relational sources?
What are the various tools used in etl?
Explain me ETL project architecture in Detail?
What are snapshots?
what is pmrep command?
What is tracing level?
What is Data Vault???