 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



 Suppose you have n no.of records @ your flat file and you have seen some of records ar..

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

 Suppose you have n no.of records @ your flat file and you have seen some of records ar..

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

Post New Answer

More Informatica Interview Questions

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


explain about informatica server architecture?

1 Answers   IBM,


Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  


What are the new features of the server manager in the informatica 5.0?

1 Answers  


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

3 Answers  






can we use bulk loading when we use look in mapping

1 Answers   TCS,


how to load rows into fact table in data warehouse

0 Answers   Informatica,


What is a command that used to run a batch?

4 Answers  


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

5 Answers   Accenture,


can every transfomation reusable?how?

2 Answers   Wipro,


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

0 Answers  


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?

4 Answers   Mind Tree, Polaris,


Categories