my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 16776 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
What is a router transformation?
How many numbers of sessions can one group in batches?
How can we update a record in the target table without using update strategy?
In informatica workflow manager, how many repositories can be created?
What is a filter transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
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?
What is resilience time?
How would you copy the content of one repository to another repository?
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?
What is the difference between writing a joiner query in ANSI style and THETA style?
Under what condition selecting sorted input in aggregator may fail the session?
How do you load unique records into one target table and duplicate records into a different target table?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
