 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 |
Which transformation should we use to normalise the COBOL and relational sources?
what is curr val use for in sequence generator?
what is the Default Source Option For Update Strategy Transformation?
What is partioning?how many types of partinings are there
where is the reject loader .
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is data driven?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?