just use the below query in SQ override:) select * from table union a

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

Question Posted / vidyasagar

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention a few design and development best practices for informatica?

1045

Explain constraint based loading in informatica

1157

What is the surrogate key?

1364

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2245

What is data transformation manager process?

1222

What is exclusive and normal mode for repository services?

1190

Explain pushdown optimization $pushdownconfig parameter - informatica

1195

Explain sql transformation in script mode examples in informatica

1211

What is meant by query override?

1118

Explain joiner transformation in informatica

1174

What are the features of complex mapping?

1209

Write the program through which the records can be updated?

1055

can anyone suggest best free Talend data integration training online

1745

How to generate sequence numbers without using the sequence generator transformation?

1265

Explain the different lookup methods used in informatica?

1098