Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

SOURECE

Name id dept sal
1 a1 A 100
2 b1 B 200
3 c1 C 300
4 d1 D 400

TARGET:

Name id dept sal
1 a1 A 100
2 b1 B 200
3 WER1 567 300
4 d1 D 400

I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5
STEPS ABOVE TABLE?

Question Posted / sreenu


SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name i..

Answer / yash

There are many ways to check this:
1. Do Column level check meaning SRC.ID=TGT.ID but others
columns are not matching on data.
2. you can do MINUS (SRC MINUS TGT) and (TGT MINUS SRC)for
particular day's load.
3. you can do referential integrity check by checking any id
valus in SRC but not in TGT or any id in TGT but not in SRC.

Hope these are enough.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is work of PUSH DOWN option

2 Answers   Wipro,

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

What is source qualifier transformation?

1 Answers  

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

What are the different clients of powercenter?

0 Answers  

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

what is the complex transformation you used in informatica

0 Answers   TCS,

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories