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
- 11438 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 is a joiner transformation and why it is an active one?
How big was your fact table
Which means the first record should come as last record and last record should come as first record and load into the target file?
How do you update the records with or without using update strategy?
What is lookup change?
What could be the possible resons of locks by user?
Explain about Informatica server process that how it works relates to mapping variables?
How we can create indexes after completing the load process?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain sql transformation in script mode examples in informatica
What are active and passive transformations?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the databases that informatica can connect to windows?
expain about the tune parameters?
What is the format of informatica objects in a repository?
