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

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

Question Posted / bk19

Answers were Sorted based on User's Feedback



Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / abhinaw prakash

You can write the query using both the source and target tables.

You can use the NOT IN and MINUS keyword.

Also you can make a mapping using both the tables and
generate a report on the missing records.

Is This Answer Correct ?    5 Yes 0 No

Data transformed successfully from Source table to target table. Now how you will ensure that the da..

Answer / snjsngh15

Select count(*) from tableA A
Where not exist( select 1 from tableA D
Where B.id=D.id)
Minus
Select * from tablesB B
Where not exist( select 1 from tableB c
Where B.id=C.id)
Or
Select * from Table A
Minus
Select * from Table B

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Why filter transformation is an active one?

0 Answers  

What is a unit Testing?

1 Answers  

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

What is hash partition?

2 Answers  

Why do you use Mapping Parameter and mapping variable?

0 Answers  

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

Write the program through which the records can be updated?

0 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories