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
- 11429 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 main use of mapplet?
What is the use of transformation?
What are the limitations of joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is dimensional table?
How does a rank transform differ from aggregator transform functions max and min?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
how to create user defined function (udf) in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Which transformation is needed while using the Cobol sources as source definitions?
Enlist the differences between database and data warehouse.
What are the different lookup cache(s)?
What is xml source qualifier transformation in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How would you join a node to the already existing domain?
