Answer / reni

Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.

Answer / krishna

By Handling on this we go for joiner tr make sure that there
is a common coloumn b/w the two tables.other wise not possible.

Answer / balanri

Hi,

I will presume this question as generic one.
In general case when we are joining 2 tables, no need to
bother about field names of it.,joining field datatypes are
only factor needs to consider..

Hence, we have 2 possible ways in informatica for joining 2
tables:-
Join 1 :
Let say , S1, S2 => 2 source tables from same db conn.
string/server with same credentials.

T1 => target table.

S1,S2 => SQ1 => Exp1 => T1

Here, SQ1 sql will take care of joins as we code sql.

Join 2:-
In case if S1 and S2 are from two different environments or
db's.

S1,S2 => Joiner Transformation J1 => Exp1 => T1.

Joiner J1 is compatible to have all options for building
Join condition.


Thanks.

Answer / anoosha

by using joiner transforamation we can join or merge the
different columns from two different table at informatica....
eg:emp;customer or dept table tak d common fields by dat
join d 2tables....

Answer / sanjay

1.By using UNION transformation we can join 2 different
table with different columns in informatica....

2.By using Sequence generator on both tables, we can join 2
different table with different columns in informatica....

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

How would you join a node to the already existing domain?

0 Answers  

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

In dimension and fact table? which one holds big data?

2 Answers  

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

What is powercenter on grid?

0 Answers