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 |
how do u extract data from different data sources explain with an example?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
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
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
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 partition points in the mapping?
when should one create lookup transformation ?
What are the new features of informatica 9 version?
what are the different forms of normalization?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
What is a mapping?