if i am having 10 records in source, i want 20 records in
target...how will you do it
Answer Posted / srinivas
if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is data movement mode in Informatica and difference between them?
What do you mean by worklet?
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?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
update strategy transformation in informatica
What is a surrogate key?
How can you generate reports in informatica?
Explain scd type 3 through mapping.
What is a dimensional model?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the mapping parameters and mapping variables?
How to open an older version of an object in the workspace?
What is meant by pre and post session shell command?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is option by which we can run all the sessions in a batch simultaneously?