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

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

How to load a relational source into file taget?

2 Answers  

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

What is the function of look up transformation?

0 Answers  

difference between shortcut and reusable transformation?

2 Answers  

Enlist the various types of transformations.

0 Answers  

What is the reusable transformation?

0 Answers  

What is a data modeling?

2 Answers