 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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Separate from a database, an information bazaar, and an information stockroom?

613


How many ways are there to create ports?

731


Define Pmrep command?

642


What is DR strategy for Informatica project?

708


How would you join a node to the already existing domain?

683






Different circumstance which drives informatica server to expel records?

556


What is an unconnected transformation?

669


What are the features of complex mapping?

651


What is primary and backup node?

706


How do you promote a non-reusable transformation to reusable transformation?

665


What is olap (on-line analytical processing?

647


What is target designer and target load order?

662


What are the different options available for update strategy?

580


What is a mapplet/worklet in informatica?

692


What is deployment group?

690