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

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

3 Answers
7372 Views
Patni, I also Faced
E-Mail Answers

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 Business Components in Informatica?

1 Answers

What is a difference between complete, stop and abort?

0 Answers

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers

Define Pmrep command?

0 Answers

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers TCS,

task is running successfully but data is not loded why?

2 Answers

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers TCS,

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers IBM,

How many dimensions are there in informatica?

0 Answers

What is the difference between a connected look up and unconnected lookup?

0 Answers

Implementation methodology

0 Answers

For more Informatica Interview Questions Click Here