Answer / chandranmca2007

We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.

If I wrong please send the answer to my mail id
chandranmca2007@gmail.com

Answer / tauseef

if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join

if its wrong send me the soulution to my id tauseefwst@yahoo.com

Answer / ash

use joiner and create 2 ports in jnr and assign the default value 1 to each of the ports.
make sure that 1 port is master port and [ the other post is detail]. Now give the condition as new-masterport=new_detailsport.

This will give the cartesian product type of join.

Answer / prathap

if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot

Answer / chandrababu.sarupuru

To join these sources we will use SQL Override function in
Source qlalifier transformation....

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

select count(1) from emp? what is the o/p?

5 Answers   TCS,

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,