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
- 10273 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
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are some examples of informatica etl programs?
How to generate sequence numbers using expression transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Explain Dataware house architecture .how data flow from intial to end?
Explain the features of connected and unconnected lookup.
What do you understand by term role-playing dimension?
How do you load alternate records into different tables through mapping flow?
How big was your fact table
How to create Target definition for flat files?
What are the different ways to implement parallel processing in informatica?
Does an informatica transformation support only aggregate expressions?
What are the uses of etl tools?
What is informatica etl tool?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
