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
- 11589 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
What are the new features of informatica 9.x in developer level?
What are the main issues while working with flat files as source and as targets ?
How can informatica be used for an organization?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to generate sequence numbers using expression transformation?
What is informatica metadata and where is it stored?
How to create Target definition for flat files?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
without table how to come first record only in oracle?
explain abt ur project architecture?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Enlist the tasks for which source qualifier transformation is used.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the modules in Power Center
