how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answers were Sorted based on User's Feedback
Answer / kasi reddy
using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table
| Is This Answer Correct ? | 3 Yes | 1 No |
What is grain of fact?
what is the meaning of upgradation of Repository?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
how do u set the size of block buffer?
What are the ETL Testing Operations?
What is granularity? Please explain with example
what is dynamic insert?
what is the difference between shortcut of an object and copy of an object? compare them?
Can u access a repository created in previous version of Informatica?
What is data modeling and data mining?
how do use session mapping parameters ?(in which transformation)
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?