if i am having 10 records in source, i want 20 records in
target...how will you do it
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guduri
to get dis dont enable the property called truncate target
table option in session properties
Is This Answer Correct ? | 0 Yes | 6 No |
difference between repository database and repository service?
What are the tuning techniques you applied during your last project
how do u move the code from development to production?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
To import the flat file definition into the designer where should the flat file be placed?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
can we override a native sql query within informatica? Where do we do it?
Differentiate between reusable transformation and mapplet.
How to identify this row for insert and this row for update in dynamic lookup cache
Define mapping and session?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?