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
Enlist the various types of transformations.
What are ETL Tools?
How would you join a node to the already existing domain?
can anyone explain me about retail domain project in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
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)
Why union transformation is an active transformation?
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?
What are the main issues while working with flat files as source and as targets ?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Is it possible to use a client with different version than that of its Informatica server?
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?
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
What is meant by lookup transformation? Explain the types of lookup transformation?
can u any challenge your project?