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

What are the different ways to implement parallel processing in informatica?

1338

What is the function of union transformation?

1060

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1083

What is the use of code page?

1004

What is transformation?

1049

Explain the use of aggregator cache file?

1185

How can we create index after completion of load process?

1070

Do you find any difficulty while working with flat files as source and target?

1050

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6907

Partition, what happens if the specified key range is shorter and longer

2430

What are the modules in Power Center

1620

What are the different options available for update strategy?

937

Differentiate between a repository server and a powerhouse?

1041

what is the -ve test case in your project.

2325

Which means the first record should come as last record and last record should come as first record and load into the target file?

1017