I have a task in which I need to take a flat file as my source and use oracle's sequence generator for a column and store into target flat file with sequence numbers including.
EXample:Source flat file
abc 1000
xyz 2000
def 3000
Target flat file
1 abc 1000
2 xyz 2000
3 def 3000
Note : The sequence numbers should come only from ORACLE (not from informatica's sequence generator Transformation).
Subscribe to:
Post Comments (Atom)
1 comment:
HI,
If you want a sequence to be generated from oracle, then better you create a stored procedure(eg:SEQ_PROC) which returns the ID generated though a sequence.In the Informatica Designer, while you create a Transformation..select the STORED PROCEDURE transformation, call the stored proc SEQ_PROC ,created above from this transformation.Link this to your required field in the Target.
Hope this helps to solve your problem..
Post a Comment