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

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

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,

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

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

5 Answers  

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

0 Answers