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

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

&#61656; Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

What is exclusive and normal mode for repository services?

0 Answers  

What are the new features of informatica 9.x at the developer level?

0 Answers  

Which kind of index is preferred in DWH?

2 Answers  

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

Can you access a repository created in previous version of Informatica?

1 Answers  

What will be the approach?

0 Answers  

For more Informatica Interview Questions Click Here
Categories