in mapping i have one source and five targets in that data
will be loaded into four targets properily
in one target the data is not loaded how will u rectify

Answers were Sorted based on User's Feedback



in mapping i have one source and five targets in that data will be loaded into four targets proper..

Answer / aravind

Check the session Run properties and session log. This will
show the no. of rows inserted into each target. Also you
can check the target data in the database level

Is This Answer Correct ?    4 Yes 1 No

in mapping i have one source and five targets in that data will be loaded into four targets proper..

Answer / chow

I think Constrain-baced loading

Is This Answer Correct ?    1 Yes 0 No

in mapping i have one source and five targets in that data will be loaded into four targets proper..

Answer / naresh

Check the run properties in session logs()workflow
monitor), that how many records are loaded in each target
adn use contrain-based loading will be work out.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In warehouses how many schemas are there?

0 Answers  


Target is zero file and how can you send the email?

2 Answers   Bank Of America,


I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


Differentiate between a database and data warehouse?

0 Answers  


to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,


What is batch and describe about types of batches?

2 Answers  


why we use source qualifier transformation?

16 Answers   Accenture,


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


select count(1) from emp? what is the o/p?

5 Answers   TCS,


What is staging area?

11 Answers  


Categories