Hi everybody, I read a lot of topic on this subject but I didn't suceed in what I wanted to do. My goal is to generate a sequence for a delimited file. For example, I have : id_connexion, id_utilisateur, date_connexion,.... My delimited file is composed like this : pierre;17/06/2008 11:11:15 jacques;17/06/2008 11:12:15 I'd like to generate a sequence to fill in the field id_connexion, this is what i'd like to have : 1;pierre;17/06/2008 11:11:15 2;jacques;17/06/2008 11:12:15 But not for a new delimited file but for a tOracleOutput. I've tried a lot of things, but I didn't find how to do. My project is in java. I have tOracleInput->tMap->tOracleOutput. Could you please help me. Thanks in advance.
Thanks for your mapping but I don't understand why do you have 2 primary keys. In my mapping, I have my delimited file on the left, my sequence in the "var" part (on the middle), and on the right side, my destination table. My sequence is link to the primary key of my destination table. I still have an error, he doesn't want to raise my sequence because he always returns "null". Do you have an idea please? I use a FileDelimited->tMap->tOracleOutput and not tOracleInput->tMap->tOracleoutput like I said. I was wrong, sorry. Thanks in advance for your answer.
Hi Megadeth2, I just designed the job for sequence generator. Here I am attaching the job and tMap. This is my tsv file: Organization City Yahoo CA Google NY AOL NJ Database MySQL: 1,Yahoo,CA 2,Google,NY 3,AOL,NJ
Var Expression: Numeric.sequence("s1",1,1)
please upload images of your job if you still face any problem. regards, sangi
Hi Sangui, Thanks for your answer, I did the same you show me but I still have the problem "null", I don't understand why he doesn't want to raise my sequence. I can't upload images, so I'll keep on searching what is the problem. Thanks a lot for yours advices.