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…….
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 handle decimal places while importing a flatfile into informatica?
What are some examples of informatica etl programs?
How do you manage the Parameter files while migrating your data from one environment to another environment?
COM components can be used in Informatica
What are batches?
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.
How to update or delete the rows in a target, which do not have key fields?
How are indexes created after completing the load process?
What is Cognos script editor?
Design a mapping to load a target table with the following values from the above source?
What all are steps in up gradation of Informatica server?
Please let me know how to make encryption and decryption with example?
Explain sessions. Explain how batches are used to combine executions?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the differences between oltp and olap?