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
- 10534 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 advantages of using informatica as an etl tool over teradata?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is an unconnected transformation?
what is Active lock explain
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist the differences between database and data warehouse.
What is DR strategy for Informatica project?
What is a passive transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of lookup transformation?
What are active and passive transformations?
Mention a few design and development best practices for informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the transformations that are not supported in mapplet?
