 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 normal and bulk loading? Which one is recommended?
explain about informatica server architecture?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What are the new features of the server manager in the informatica 5.0?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
can we use bulk loading when we use look in mapping
how to load rows into fact table in data warehouse
What is a command that used to run a batch?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
can every transfomation reusable?how?
Separate from a database, an information bazaar, and an information stockroom?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?