DSXchange

aschand wrote:Please can any one help me in creating a table definition for a spread sheet data....

I do not know the procedure.

Thanks
aschand

save spred sheet in the format of .csv and create as medata like sequential file.

Hi,

I am facing one problem with tranformer surrogate key tab.
if any body did the Parameters in surrogate key tab for database sequnce type please assest me the same.

Thanks,
Praveen.

I did type1 and type2 in datastage 8 it is working fine their is no problem with datastage check once the purpose codes are set properly or not and check database constraints also it very impartent.

I want one clarification how you are passing parameters in SurrogateKey tab for database connection.

chulett wrote: What command? Either supply a full path or explicitly 'cd' there first. ...

command: ls -1|grep "xyz"|sort -u -r -t"." +5|head -1
parameter:etl/source/data

If the metadata are different for each file create ten separate jobs to do the validation. Take OK triggers from each job activity into a Sequencer set to fire only if All of its inputs have fired. Ma ... Hi Ray, All things was done properly. The exact problem is now i am getting here when i am try...

If the metadata are different for each file create ten separate jobs to do the validation. Take OK triggers from each job activity into a Sequencer set to fire only if All of its inputs have fired. ... Hi, The validation jobs all were done.The problem is i need to run all jobs one time for that i n...

The meta data is different for all.If one file fail all should stop the process.

Thanks,
Praveen

All validations and transformations done.we need to arrange the jobs in a sequence. In one sequence we need to process all file validations.For that i need to read files one by one but I dont want to read one by one I want to read all 10 files at one time. By using which stages and which job design ...

Hi, I need to read 10 files from the single directory.These files are different file name and different data for different table loads. The process will run in two phases one is validation if it is success then start the second phase transformation otherwise the whole process needs to be stoped. we ...

ray.wurlod wrote:It is not possible to use database constraints in an SCD stage therefore I ask again for you to describe exactly what you are doing in the SCD stage. ...

HI ray,

before that it in the database their is no constraint thats why it was did.

Thanks,
Praveen

ray.wurlod wrote:Describe - exactly - how you have set up the SCD stage - ideally with a picture of each tab. ...

Thanks for your reply.

I was done by using database constraints.

Hi, i have developed one job.In that i am trying to maintaine the SCD Type2 updates. my job design is like this: DBstageLookup | | V seqFile------>SCD-------->SeqFile | | V DBstageUpdate it is every time inserting two new records one with old values and one with new values. The problem the record is...

this problem comes because of when you dont have the columns(currentIdicator or expire date) in lkp table it will give this compile error

ray.wurlod wrote:Search for "failed to load" would be a good start. Then investigate your shared library search list environment variable.

Edit your post and check th ...

do you mean libpath environment variable in general section

Hi,
My Job Structure is like this

Seq Stage-->XML input-->Seq Stage

I am getting the following error,

Main program :Fatal Errorr: Fatal: Shared Library (xmli.so) failed to load error =(8)

Any ideas

Thanks in Advance
Praveen