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 / guest
we can join two table by using source qualifier t/r
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
| Is This Answer Correct ? | 4 Yes | 1 No |
Can u access a repository created in previous version of Informatica?
What are snapshots?
dimension object created in oracle can be imported in designer?how?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
What are your responsibilities as an etl tester?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
What are the new features of informatica 9 version?
what is the advantage of persistent cache? when it should be used?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?