drop unique constraint in target table and select only insert in session t

if i am having 10 records in source, i want 20 records in
target...how will you do it

Question Posted / jz

Answer Posted / jz

drop unique constraint in target table and select only
insert in session target properties run the session twice.

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Separate from an archive server and a powerhouse?

905

Mention a few design and development best practices for informatica?

933

What is data caches/ index caches?

1020

Can you generate sequence numbers without using the sequence generator transformation?

1049

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2097

Briefly describe lookup transformation?

982

How do you convert single row from source into three rows into target?

1090

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1171

How does the aggregator transformation handle null values?

1084

What are the restrictions of union transformation?

976

Differences between version 7.x and 8.x.

1840

Enlist the differences between database and data warehouse.

1033

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1893

What is primary and backup node?

1080

What is meant by lookup transformation? Explain the types of lookup transformation?

899