my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
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
How to delete duplicate row using informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What all are steps in up gradation of Informatica server?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can you generate reports in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Clarify the utilization of aggregator cache record?
What do you mean incremental aggregation?
Enlist the differences between database and data warehouse.
Tell me about Propagate functions in informatica
define galaxy repository in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can you generate sequence numbers without using the sequence generator transformation?