Answer / sbvp

by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok

Answer / manjunath

Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R

Answer / ankit kansal

Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.

http://deepinopensource.blogspot.in/

Answer / sarthak

U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.

Answer / sivaraj c

Use indirect Load through reference file which holds the file name of both source files.

What are the mapings that we use for slowly changing dimension table?

2 Answers  

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

how do u move the code from development to production?

3 Answers  

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

What are the informatica performance improvement tips

0 Answers   Informatica,

What are the data movement modes in informatcia?

3 Answers  

What is the Difference between sorter and aggregator?

2 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

What is status code?

2 Answers