my source having 10 records but how can i load 20 records in target, i am not

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?

Question Posted / dathu

10 Answers
18949 Views
Cap Gemini, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / rajesh

Take the source into expression and map it to instances of
target.

Is This Answer Correct ?

12 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / naga

Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target

Is This Answer Correct ?

13 Yes

4 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / vidyasagar

just use the below query in SQ override:)

select * from table

union all

select * from table

Regards:
Vidyasagar

Is This Answer Correct ?

9 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / ram

sq---router(2 conditions which should be satisfied)---and passed to target.
will do the work

Is This Answer Correct ?

7 Yes

1 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / sujana

use union transformation..connect source to multiple grps of union transformation..

Is This Answer Correct ?

5 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / abhishek

Through normalizer it is possible just give all feild's
occurance as 2 time and link it from source. It will work.

Is This Answer Correct ?

3 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / jay

Very Simple method

QRC-----> TRGT
|
----> TRGT

Have two instance of target and
connect source to both target instances.

Is This Answer Correct ?

2 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / subhransu panda

Through session partition we can achieve this.
Create 2 parallel pipeline and don't override the partitions in mapping properties.

Is This Answer Correct ?

0 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / kamleshmishra291

After SQ use Java transformation

SQ--Java transformation

for(int i=0;i<2;i++)
{
output_port=input_port;
generateRow();
}

Is This Answer Correct ?

0 Yes

0 No

my source having 10 records but how can i load 20 records in target, i am not bother about duplica..

Answer / soujanya

create an instance of target

Is This Answer Correct ?

0 Yes

2 No

Post New Answer