What are the basic needs to join two sources in a source
qualifier?

Answer Posted / ricky

Both the sources should come from homogenious / same
database.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the various types of transformations.

554


What are ETL Tools?

664


How would you join a node to the already existing domain?

675


can anyone explain me about retail domain project in informatica?

7430


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

720






I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1076


Why union transformation is an active transformation?

652


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

549


What are the main issues while working with flat files as source and as targets ?

648


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

729


Is it possible to use a client with different version than that of its Informatica server?

642


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?

1455


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1668


What is meant by lookup transformation? Explain the types of lookup transformation?

566


can u any challenge your project?

1602