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

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

Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2335

What are connected or unconnected transformations?

1119

Whats there in global repository

1692

define galaxy repository in informatica

2225

What are the types of presistent cache in look up tr.

2053

expain about the tune parameters?

2414

How does the aggregator transformation handle null values?

1147

What are some examples of informatica etl programs?

940

What is repository manager?

984

Explain dynamic target flat file name generation in informatica

1048

What is joiner change?

1146

What is an active transformation?

1098

What are the reusable transformations?

1160

What is flashback table ? Advance thanks

1930

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105