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
- 10068 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
Under what condition selecting sorted input in aggregator may fail the session?
How do we call shell scripts from informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the steps involved in the migration from older version to newer version of Informatica Server?
whats the logic to load the lower level of granularity of data to fact table.
Why update strategy and union transformations are active? Explain with examples.
Plz can any one say me how to get the informatica certification materials and dumps
How to load the data from a flat file into the target where the source flat file name changes daily?
During the running session, output files are created by informatica server. Enlist few of them.
Can we create a Integration service without a Repository service and vice versa?
What is sequence generator transformation in informatica?
How to create a non-reusable instance of reusable transformations?
list out all the transformations which use cache?
State the differences between sql override and lookup override?
What are the transformations that are not supported in mapplet?
