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?
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 an aggregator transformation?
update strategy transformation in informatica
What is the need of an ETL tool?
Explain in detail scd type 2 through mapping.
What is DR strategy for Informatica project?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain what are the different versions of informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define update strategy?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is powercenter on grid?
Under which circumstances, informatica server creates reject files?
What are the advantages of informatica?
How to partition the Session?