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 |
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
what is unique constraint error ?
how can we use sorter transformation in joins?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
what are the unix commands to start the wrk flow ?
what are the types of Data warehousing ?
How to fix the etl bugs..Tell me the process?
How can you define a transformation? What are different types of transformations in Informatica?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,