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.

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

who to split dimentions into sub dimention

3 Answers   Wipro,

what are challenges that you faced in testing? give solution to it?

1 Answers  

why we use materialized view over view?

1 Answers   Zensar,

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

What do you mean by blocking transformation?

0 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

explain different types of modeling.

2 Answers  

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

How can informatica be used for an organization?

0 Answers