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
- 11201 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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is meant by LDAP users?
What does role playing dimension mean?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to load data in informatica ?
What is rank transform?
Design a mapping to load a target table with the following values from the above source?
How do you handle two sessions in Informatica
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is Active lock explain
Can we change Dynamic to Static or Persistent cache? If so what happens?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the difference between STOP and ABORT options in Workflow Monitor?
What is an active transformation?
What are junk dimensions?
