if soource is having 10 records how will u insert 20
records to target
Answer Posted / sreekanth
select * from table_name
union all
select * from table_name;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to do the error handling of if ur source is flatfiles?
How to generate sequence numbers?
can you please explain me pre session and post session options?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the benefit of session partitioning?
what is size of u r database?
without table how to come first record only in oracle?
What is informatica metadata and where is it stored?
Make a note of the quantity vaults made in informatica?
How many ways a relational source definition can be updated and what are they?
Tell me about Propagate functions in informatica
What are mapplets?
Describe data concatenation?
generate date / time dimension in informatica
What is meant by a domain?