1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / venkat

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

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

in performance wise union is past,union all is past

2 Answers  




How is union transformation utilized?

0 Answers  

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

how we do performence tuning in informatica

3 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

what is mean by flag 4 in update strategy t/r

6 Answers  

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

Define maping and sessions?

3 Answers  

For more Informatica Interview Questions Click Here
Categories