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....

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

how to we create datamart?

2 Answers   HSBC,

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

WHat all joins are there in Source Qualifier?

1 Answers