Interested to Buy Any Domain ? << Click Here >> for more details...
My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
- 7 Answers
- 9834 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / rahul
source>sq>exp>trg_1
>trg_2
take 2 seq gen
1)seq1 tnx n set properties
start_value=10
increment_by=10
end_value=110
current_value=10
cycle enable
reset enable
connect nextval to target1
2)seq2 tnx n set properties
start_value=11
increment_by=10
end_value=110
current_value=11
cycle enable
reset enable
connect nextval to target2
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
How to go to the older version for a mapping?
What is a code page?
can u give example for factless fact table
How to do unit testing in informatica?
Is it possible to use a client with different version than that of its Informatica server?
What is blocking transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is workflow monitor?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Target increases every day even though no new record was inserted
Informatica Checkpoints
What is transformation?
Explain load alternative records / rows into multiple targets - informatica
What is a connected transformation?
