 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 |
What is the difference between informatica 7.0 and 8.0?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
without dynamic lookup how to insert new rows and update existing rows?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
what is the necessity to use update strategy?(except for updates)
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
in what type of scenario bulk loading and normal loading we use?
draw informatica architecture 8.6 ?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?