Interested to Buy Any Domain ? << Click Here >> for more details...
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
- 5 Answers
- 11166 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
If both exist in same database then you can use NOT EXIST
function to find out the missing rows.
If both exist in diff databases then you can join them using
joiner and compare the rows in expression and Raise a Flag
for not matching rows.You can then use filter and pass only
the non matching rows into the target.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
What are the different transaction levels available in transaction control transformation?
Explain informatica architecture - version 8 / 9
is it possible to index the data in cache of lkp transformation ?
tell me 5 session failure in real time how can you solve that in your project?
Why is sorter an active transformation?
What is parallel processing in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Did u used latest transformations of 8.6.0? for what?
How to delete duplicate row using informatica?
What is a dimensional model?
What is target load order?
Briefly explain the aggregator transformation?
how we can load rejected record's at run time?(not through bad files)
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??
