DSXchange

Hi, Lookup_7,0: When binding input interface field "Column1" to field "Column1": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use a modify operator to specify the value to which the null should be converted. How to solve the above issu...

Hi,

The DataStage Server and Clients installed in Windows Operating system.

How to unlock the job in windows?


Thanks,

Hi, the Source data as follows: Col1 Col2 1 aa 2 gg 1 aa 2 gg Required output: Col1 Col2 1 aa 2 gg need to identify the duplicate record existance. based on the first row if any duplicates occurs the error message needs to send into error table, if the duplicate does not exist the record will load i...

the WeekDayFromDate function will display the number of the day in week, it will not display the name of the day.

Thanks,

Thanks,

But by using DateToString(), there is a option to display the day number ( 1-31), how to display the day name?

HI,

in datastage 7.5 ( parallel jobs), how to display the 'day' from the Date value.


Thanks,

Hi,

I have two servers, one for Datastage and another for Database.

I created the DSN connnection for the database in two servers( tried with individual server also), but that DSN not displaying in datastage.

How can i solve this?

Thanks,

Hi,

while view the data from sybase source stage using VIEWDATA option am getting the error as follows.
(DataStage version: 7.5.1)

BATS_STG.DSLink1: DSP.Open GCI $DSP.Open error -100.

Many thanks,

Hi,

i installed the DataStage in my system.. while executing the parallel jobs am getting the error as follows.

Error: view data Command executing..

how can i slove this..

Thanks in advance..

Hi,

i have installed the DataStage in my system. but while running the parallel job the following error is displaying:

Error : Executing the View Data Command.

Please give me the solution..



Thanks,

Hi, In source the data as follows ( having two columns). Col1 Col2 1 AAA 2 BBB 1 AAA 3 CCC 1 AAA The required output as follows. Col1 Col2 Flag 1 AAA - 1 AAA D ( Duplicate Record) 1 AAA D ( Duplicate Record) 2 BBB - 3 CCC - Thanks a lot,

Hi,

In source the data as follows ( having two columns).

1 AAA
2 BBB
1 AAA
3 CCC
1 AAA

The required output as follows.

1 AAA
1 AAA D ( Duplicate Record)
1 AAA D ( Duplicate Record)
2 BBB
3 CCC

( In third column the flag needs to display)

Thanks a lot,

not for the interview... for learning purpose only...

Please reply me..

Thanks,

not for the interview... now am learning...

Please reply me..
Thanks,

What is the use of Partition table option in oracle stage in parallel jobs