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.

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

How can we use batches?

0 Answers  

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

Repository user profiles

0 Answers  

What are the popular informatica products?

0 Answers  

Which kind of index is preferred in DWH?

3 Answers  

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

Define update strategy?

0 Answers  

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

What are different types of transformations available in informatica?

0 Answers  

How do you remove duplicate records in informatica?

1 Answers  

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers