DSXchange

Watching this dialogue, I dont think its clear to the rest of us why you describe an issue of having to end up with three different "paths", that have to be brought back together... as David states, the three lookups can simply be performed in a single transformer stage, with one row in and one row ...

Hi Tunde, in the first transformer you can fit you rows for lookup in any combination you like with your parameters and in the second transformer, which is followed by the first you make your 3 reference lookups. Wolfgang -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@tar...

Hi Wolfgang, I know the two products are very different and im not really trying to bash datastage. i guess i just frustrated as to how to get this done. thanks for all you guyss help. I will try out what you have suggested and would let you know. thanks again guys. -----Original Message----- From: ...

what about the extra parameters that are needed for the lookups. i guess, im not so sure of how to do that. there are also four parameters to pass in order to do the lookup for each column. -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Tuesday, July 08, 2003 9:07 AM To...

Why couldnt you simply use 1 transformation stage with 3 lookups links (one for each column you need to decode)? I am missing why you need to split the columns and remerge them later, shared containers can be a powerful tool but Im missing the need for it here. If you really need to do split and rem...

Maybe Im missing something here, but why not have 3 lookups, one for each of the 3 columns. This way, one input row still results in one output row, with each of the 3 columns transformed. -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com] Sent: Tuesday, 8 July 20...

Hi Tunde, for sure it will be also such an easy thing for datastage, but the philesophy of both products are different, you dont do same things the same way. Perhaps by forgetting Informatica, when working with datastage you may be better of. For a good performance you first put the code-translation...

I have been trying to explain what i want to do but no one seem to understand it. i have data coming from a source. my data has 7 columns. out of the 7 columns, there are 3 codes that needs to be converted into different codes based on some parameters. thus, i need to parform a lookup on a database ...

Hi Tunde, which database? Folks have complainted weeks ago, that in the past a routine, which accessed a Database via ODBC worked fine, but after upgrading it worked no more and Ascential was saying talk to Merant the ODBC-driver-provider and Merant said, Ascential has to solve it because it is OEM....

is it possible to write a routine that access the database, performs a lookup and returns a value based on two or three argu passed to it?

Tunde

Isabelle, I had a similar sort of thing in which i had a header table and varied no. of detail rows. Header used to be 1,A 2,B 3,C Detail table 1,AA 1,BB 2,CC 3,DD 3,EE 3,FF O/P had to be H,A I,,AA(Only 2 Details) I,,BB H,B I,,CC(only one detail) H,C .....(3 Detail records) The above i used to handl...

Yes, I think youre right. I didnt read the original post accurately enough. And the documentation for that says "any SQL statement", but it cant manage CALL (so it looks like programmatic SQL is not supported). However, ALTER SESSION can be done interactively. So I guess its a case of try it and see...

When I do this I do as Kim has indicated but additionally make the output file with no line term. HeaderRec1::Detailrec1::Detailrec1A: HeaderRec2::Detailrec2::Detailrec2A: On the OUTPUT side of this target file, set line Termination LF and you can process or read single column. This will give you: H...

What is the basis for deciding if you need to do an insert or an update? If there is something in the data that indicates this, then perhaps you can sort the data before presenting it to the OCI stage, so that all inserts happen first. On the other hand, if your decision to insert or update is based...

Ray, On the Oracle OCI8 stage (DataStage v6.0.1.5), on the SQL tab there are "Query, "Before", and "After" tabs. The help file for the OCI8 stage says the "Before" tab "...Contains the SQL statements executed before the stage processes any job data rows..." and the "After" tab "...Contains the SQL s...