Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23528 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / balanri
Hi,
I will presume this question as generic one.
In general case when we are joining 2 tables, no need to
bother about field names of it.,joining field datatypes are
only factor needs to consider..
Hence, we have 2 possible ways in informatica for joining 2
tables:-
Join 1 :
Let say , S1, S2 => 2 source tables from same db conn.
string/server with same credentials.
T1 => target table.
S1,S2 => SQ1 => Exp1 => T1
Here, SQ1 sql will take care of joins as we code sql.
Join 2:-
In case if S1 and S2 are from two different environments or
db's.
S1,S2 => Joiner Transformation J1 => Exp1 => T1.
Joiner J1 is compatible to have all options for building
Join condition.
Thanks.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the types of schemas we have in data warehouse and what are the difference between them?
explan ur project architecture?
What are mapplets?
What are junk dimensions?
What is the sequence generator transformation in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the reusable transformations?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is meant by query override?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different types of transformation available in informatica.
What is Data Caches size?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
