two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
Answer Posted / venu
by using seeion parameters
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
Did u used latest transformations of 8.6.0? for what?
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?
What all join we can perform in LOOKUP transformation?
What are the informatica performance improvement tips
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Different sorts of metadata that stores in the storage facility?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the different types of transformation available in informatica.
What is session task and command task?
What are the databases that informatica can connect to windows?
What is a pre-defined event and user-defined event?
What are the differences between a connected lookup and unconnected lookup?
What is blocking transformation?
Can u generate reports in Informatica?