DSXchange

Thank you! @Chulett: What I mean by meaningful data is exactly as you said phone numbers should be generated which look like phone numbers and the same with names and addresses they should be like real names and real addresses. The data to be generated is huge could be around 200 to 300M records. @R...

Hello everyone

Can anyone please let me know if there is any way where I can generate data using datastage, If I do not need a meaningful data I can use random function but what will be the solution if I need meaningful data

Any input is appretiated

Thank you

Thank you all very much!

I will use one of the above replies depending on my job design.

Thank you Ray and SURA!

The below given solution answers my second question which is checking for the field order and field names.

Is there any way where I can check whether the file is CSV or not in datastage? or is it something to be done in Unix before reading the file

Hello everyone

I need to read a CSV file as source and need to validate whether the file is in CSV format.
The columns should be validated whether they are in the required order or not.
The column names with should be validated with certain names.

Please suggest a way to make it doable.

Thanks

Followed the same way....Its great....



Thanks

My problem is solved ,

I forgot giving a null field value in the sequential file.

I can view the output now.

Thanks.

I tried the same way two transformers.......into a funnel and then.....one link to output which is right now a sequential file. But the problem is I cant view the data. No records foun in view command would you like to see the data If yes ##I IIS-DSEE-TOSH-00002 12:43:21(001) <main_program> orchgene...

thanks ernie,

watch out for null representation.....so check for the null values whether the output has null values or not?

Is the below way better? first output------>using a tranformer...lets say trans1 with 5 fields input and 5+ 20 fields output where 20 fields are Setnull(). secondoutput------->using a transformer.lets say trans2 with 20 fields input and 20+5 fields output where 5 fields are Setnull(). now funnel for...

Thank you, The request I get is unique_id there are 3 tables in the database. 2 tables have active information and 1 table has inactive information. when the unique_id comes in as a request I need to check whether it is in the 2 tables or the other table. I used look-up for that...so the active uniq...

Actually, My input is a single field but there are two kinds of outputs ..............I mean one has 5 fields and the other one has 20 fields. so Funnel will not help me with this issue? does datastage has a stage which can send different outputs to single output........ I mean If input matches with...

So If I use linkconnector or funnel stage I can get 3 outputs in a single wisd output based on three conditions. my conditions are for ex:- 1.If ID = A then msg:- no records because A 2.If ID = B then msg:-no records because B 3.other than this any ID send all the records. can I use these conditions...

In the designing of my job I need to send three seperate responses to the service based on the conditions.

so for that reason can I use 3 WISD output stages because all the conditions are different



Regards,
Rahul

How to generate WSDL?