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

difference between repository database and repository service?

0 Answers  

why we use materialized view over view?

1 Answers   Zensar,

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

What is status code?

2 Answers