DSXchange

Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics. :wink: good to see a serious response on this :wink: :wink: :lol: the world of missing smiles :oops: Every person in a state of uniform [rational] mind tends to remain in that state of mind unless an external ...

mmanes wrote:Hi everyone,

How I'can made a connection with SQL Server?

Please help me!

Thank you

try SQL server enterprise stage if you have 7.5x

Try another approach. Are you doing your lookup against entire dimension table ? Maybe creating your lookup files one step before might be more performing and gives you the possibility to have your rejects per table. that's exactly what i meant to say ,ie., to have lookup filesets and do sequential...

Hi all, Is there a simple way to pevent an ftp if the file doesn't contain any records? My job is currently creating a zero length file. I know I could write an after script to do this but just wanted to confirm that was the only way. 1)use a contol job and check for the readiness of the file befor...

I have solved this problem. It has to do with the order in which Constraints are enabled .. We have given name to Primary Key (on Col1 in Eg) which comes later, in alphabatical order, than the reference_key name in question. So DS tried to enable FK but by that time the PK is not yet enabled. If I ...

meena wrote:Hi prabu,

Using five transformers may have performance issue and of more cost.

Hi Meena,
that is more towards answering , "is there any way" [ instead of is it the best way]

Hi All, My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason. Regards, RAGHU maybe, just maybe.... Tables can neither be created nor be destroyed but can be converted from one form i...

Thanks for your responses. But. let me frame my question much better. I am actually loading my FACT table. In this process, I have 5 Dimension tables linked to the Fact table(PKs of the DIM tables as FK's in the Fact). Before loading records to the Fact, I do a Lookup to each of the Dimension table...

I am having trouble deciphering an error message I'm receiving in a parallel job. The job has an inner join stage with two Oracle stages as the sources for the join. The first Database stage ahs a simple SQL select as the data source. The second stage has the following: SELECT EVENT_PARTICIPANT_MON...

Perhaps an all-NULL row does not get written into a bad file. Check with your Oracle DBA or Oracle documentation. Or experiment outside of DataStage. ... Ray, you are right! all null reocrds go to discard file but datastage takes into account only 1)control file 2)log file 3)parfile and 4)bad file ...

Are you using the DataStage SQL Load stage to BCP the records into the database? Sounds like an obvious question but i just wanted to be sure. If you are then there must be an option in the load stage whether to remove the temp files or not. I know for sure that the UDB load stage has that option, ...

misleading topic of this millenium :shock:

prabu wrote:Hi DS folks,

2) i can't find the bad file + param file generated, i see only control + log file even when there is a failure[is it the default behavior??]

please let me know

regards,
Prabu

any pointers??

Options: ------------ Oracle_Enterprise_52: Oracle call failed; sqlcode = -2270; message: ORA-02270: no matching unique or primary key for this column-list Oracle_Enterprise_52: ExecuteImmediate failed for: alter table table1 enable constraint Oracle_Enterprise_52: Unable to enable constraint "...

There are many ways. Possibly the easiest is to follow the Row Generator stage with a Copy stage whose second output sends rows to a file. ... Good idea, Ray! BTW, could someone pls explain about the bad file and param not being accessible after a sqlldr failure. Meaning they are not being created,...