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

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

explain about lookup t/r?

1 Answers   IBM,

What are the different options available for update strategy?

0 Answers  

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

What all join we can perform in LOOKUP transformation?

0 Answers  

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

When do you use mapping parameters? (In which transformations)

1 Answers  

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

What is joiner cache?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories