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
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
tell me few points when u become TL
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?
what is an ETL or ETT? And what are the different types?
what is Forward,Reverse and Re_engineering?
where is the cache (lookup, index) created and how can you see it.
Can u access a repository created in previous version of Informatica?
what is the meant by Normalization and de-normalization?
what is the difference between cardinality and Nullability?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is the difference steps for data modeling?
how to load the data to fact table?
What are the types of Data Warehouse applications?
explain the methodology of Data Warehousing?(Polaries)