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
- 11224 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
Repository user profiles
Explain the etl program with few examples.
what are the Methods For Creating Reusable Transformations?
Explain joiner transformation in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to generate sequence numbers?
How you know when to use a static cache and dynamic cache in lookup transformation?
What can we do to improve the performance of informatica aggregator transformation?
What are the different lookup cache(s)?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a stored procedure transformation?
Explain lookup transformation source types in informatica
Please let me know how to make encryption and decryption with example?
Explain target update override in informatica
