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
- 5733 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Compare etl & elt?
When do we analyze the tables? How do we do it?
What is the difference between project backlog and product backlog?
Explain me ETL project architecture in Detail?
How to fine tune mappings?
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.
what are the data modeling tools you have used?(polaris)
Can we create Hierarchies in generic datasources?
what is data modeling?
what is the use of structures?how many nodes can u create in a structure?
How many steps etl contains?
what do u do when DB time takes more?in sap bi
Identifying the bottlenecks in various components of Informatica and resolving them.
list and discuss two approaches for updation of target table in Informatica and how they are different.
tell me few points when u become TL
