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

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


Repository user profiles

0 Answers  


What are the data movement modes in informatica?

0 Answers   Informatica,


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  






On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


What is meant by a domain?

0 Answers  


What is a predefined event?

0 Answers  


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


Did u used latest transformations of 8.6.0? for what?

0 Answers  


Categories