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 guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

what is the size of ur database(like oracle)

2 Answers   HP,

What is Code Page Compatibility?

1 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

what is difference between mapping and mapplet ?

2 Answers   TCS,

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,