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?
- 1 Answers
- 4208 Views
- IBM, I also Faced
- E-Mail Answers
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 |
can we override a native sql query within informatica? Where do we do it? How do we do it?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What is meant by incremental aggregation?
What is operational data source (ODS)?
In which transformation you cannot drag ports into it?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Teradata 
