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

What are parallel querys and query hints?

1 Answers  

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

tell me the push down optimization

2 Answers   Wipro,

What is target update override

2 Answers   CTS,

Scheduling properties,whats the default (sequential)

0 Answers  

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

What is an expression transformation?

0 Answers  

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers