Interested to Buy Any Domain ? << Click Here >> for more details...
How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
- 2 Answers
- 5827 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saravanan
use Minus query.
Select * from Source
minus
select * from Target
If you minus from Target, it will not gie you tHe Corret result sinCe all Values from target are from soure. We need to minus from sourCe. tHe rejeted reords wHICH are not populated into target will Come as result
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / alekya
use Minus query.
Select * from target
minus
select * from Source
This will give all the rows of sorce data which are
rejected,that is not loaded into the target.
| Is This Answer Correct ? | 1 Yes | 6 No |
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the difference between date cache and lindex cache?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what is the difference steps for data modeling?
In Which Transformation We Can Use Having Clause In Informatica?
Compare ETL & Manual development?
What is tracing level and what are the types?
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
Teradata 
