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 |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
how we do performence tuning in informatica
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
How to display null values on a target & non-null values on a target?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What are the basic needs to join two sources in a source qualifier?
What is the difference between Active and Passive transformation?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Explain how to import oracle sequence into informatica?
What is a taget load order?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What is the commit type if you have a transaction control transformation in the mapping?