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
7529 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

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers Accenture,

What are the types of caches in lookup? Explain them.

0 Answers

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers Informatica,

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers Wipro,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers Patni,

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers TCS,

how to sort date field in infomatica?

2 Answers

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers Puma,

How to use Normalizer transformation?

2 Answers

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers TCS,

For more Informatica Interview Questions Click Here