how to join the 2 different table with different columns in
informatica?

Answer Posted / krishna

By Handling on this we go for joiner tr make sure that there
is a common coloumn b/w the two tables.other wise not possible.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various types of transformation?

646


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

797


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5848


How to use procedural logic inside infromatica?

642


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1925






explan ur project architecture?

1599


What is a mapplet/worklet in informatica?

692


What are the informatica performance improvement tips

620


Where are the source flat files kept before running the session?

629


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1467


What is a router transformation?

635


tell me about your project functionality

1870


What is data transformation manager process?

626


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2301


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702