1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / jeyakumar.uv

Answers were Sorted based on User's Feedback



Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / ranjan

You can use the minus keyword

Source table name is A
Target table name is B.

Query can be

select * from B
minus
select * from A

or else you can do a minus from A to B.

select * from A
minus
select * from B


Inthis way you can find the mismatch
(Note: This is just one way pf comparing)

Thanks,
Ranjan

Is This Answer Correct ?    5 Yes 2 No

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / 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

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / abhinaw prakash

We can use lookup transformation to stay away from these
problem and can lookup the target columns befor entering the
data.

Is This Answer Correct ?    1 Yes 0 No

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / rakesh

What if A and B eixist in different Databases..?

Is This Answer Correct ?    0 Yes 0 No

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in..

Answer / rakesh

if source n targer exist in
different databases you can
create Database link in any of
the database for other one..

create database link "dblink
name"
connect to schemaname
identified by password
using 'Database name';

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

tell me the push down optimization

2 Answers   Wipro,

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

what is the difference between repository & Intergration service

1 Answers  

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

Repository user profiles

0 Answers  




1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

How to do unit testing in informatica?

0 Answers  

how many session run unix environment what command using ?

1 Answers   HCL,

How the informatica server increases the session performance through partitioning the source?

1 Answers  

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

For more Informatica Interview Questions Click Here
Categories