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 union transformation in informatica?
What are the differences between source qualifier and joiner transformation?
Is there any target staging area in informatica not staging area
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is joiner change?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a grid in Informatica?
What is the fact table?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do you migrate data from one environment to another?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the different lookup cache(s)?
Differences between connected and unconnected lookup?
How to update or delete the rows in a target, which do not have key fields?
How many ways are there to do 'remove duplicate records in informatica'?