two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23413 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / ram kumar
Using Joiner Transformation, to compare the two tables.
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
What is a difference between complete, stop and abort?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Briefly define reusable transformation?
What is status code in informatica?
What are the tuning techniques you applied during your last project
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How do you load unique records into one target table and duplicate records into a different target table?
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)
What are the guidelines to be followed while using union transformation?
Explain the etl program with few examples.
How many ways are there to create ports?
What is meant by query override?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is meant by target load plan?
