If source is having 5000 rows,and if you want to load data into 500 rows to tar

If source is having 5000 rows,and if you want to load data
into 500 rows to target,if the session runs successfully,how
can you verify the target if the rows are successfully
loaded or not.

Question Posted / ashok

3 Answers
8899 Views
IBM, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session r..

Answer / abhishek upadhyay

Through session log/run properties I can see how many rows
were inserted in the target table

Is This Answer Correct ?

15 Yes

0 No

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session r..

Answer / krish

session statistics

Is This Answer Correct ?

4 Yes

0 No

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session r..

Answer / raveendra g

By using Testload option, we can test the rows.

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More Informatica Interview Questions

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers CSC,

what is semi-additive fact?where did u used?

2 Answers

How to improve the performance of a session using sorter transformation?

0 Answers Informatica,

What are different types of transformations available in informatica?

0 Answers

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers IBM, TCS,

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers TCS,

what is the difference between stop and abort?

3 Answers TCS,

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers Wipro,

Explain the pipeline partition with real time example?

0 Answers Informatica,

What is the session task and command task?

0 Answers

For more Informatica Interview Questions Click Here