 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?
Answers were Sorted based on User's Feedback
Answer / vikram
While populating to target rejected loads will be loaded in
to bad files and we can cross check the data there and the
other way is run the load in verbose mode to check the
exact reason this happens when the flat file data is not in
correct format.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sarat
The above method tells us how many are missing, after that take the TARGET as Dynamic LKP and update the target for All rows to be loaded
| Is This Answer Correct ? | 0 Yes | 0 No |
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
How is Data Models Used in Practice?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
How do we implement materialized view?when to use materialized view?
What is a dimensional model?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
What is persistent lookup cache?
How to Join Tables my Source is having 15 table target is one?
Enterprise data warehouse your projects phase by phase explain?