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.

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

Mapplets can you use an active transformation in a mapplet,

1 Answers  

Define pmcmd command?

0 Answers  

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

How to do the error handling of if ur source is flatfiles?

0 Answers  

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

why we use informatica in our project?

2 Answers   TCS,

WHat all joins are there in Source Qualifier?

1 Answers  

What is Code Page Compatibility?

1 Answers  

what is datamart

4 Answers   IBM, Informatica,

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,