DSXchange

Hi ,

I have below scenario.

we receive data from a file as below

Record
col1
col2
col3
col4
col5
Record
col1
col2
col3
col4
col5
The same pattern continues ..and it should be loaded into table as below
Record col1 col2 col3 col4 col5.
Please advice me

Vertical pivot should be used right ?

Hi ,

I have a scenario below

SID QuestionNo AnswerInfo
101 1 A1
101 1 A2
101 1 A3
101 1 A4
101 2 A2
101 3 A5

My o/p should be

SID QuestionNo AnswerInfo

101 1 A1 ,A2 ,A3 ,A4
101 2 A2
101 3 A5

Please let me know

Hi,
can i use cast function to fetch a non nullable column to make it as nullable while extracting from a db2 connector to a dataset.

Hi , The requirement is that 1 value in the column 1 should not contain multiple values in column 2 and similarly 1 value in the column 2 should not contain multiple values in column 1. Data coming like this from source Column1 Column 2 1 A 1 A 1 B 2 C 3 C 4 C 5 E 5 E 6 F All three records should be...

Source is sql server

Chulett, The rest should be output 2.The logic is that for each value in column1 there should be only one value for column 2.so 1 A 1 A 1 B. 1 shouldnt contain two values,if it has it need to captured as duplicates. 1 A 1 A 1 A Even though these are duplicates,they are valid.As it contains only one ...

I have below records coming from source in this scenario Column 1 Column 2 1 A 1 A 1 B 2 A 2 A 3 Z For the column1 if it has multiple values it need to be captured seperately. Output1: Column 1 Column 2 1 A 1 A 1 B So if column1 contains multiple values in column2 those should be captured.please let...

Thank you

Hi ,

Can we connect to Sql server using Windows authentication in Datastage because i heard that odbc drivers doesn't support windows authentication and only support sql authentication.Can any one let me know on if it is true.

We have an sql server as database for a source system.The data connection has been setup for the same.While i am able to connect it through toad but when trying to connect in datastage through import wizard, i am getting timed out error.so can anyone let me know what is the exact problem cheers, Sagar

Hi,
Need to know the script for deleting temporary datasets created after sucessful completion of the jobs.

The source is an XML file and that is the client's requirment

Hi ,
Our requirment is that suppose we are getting values 1,1,1,2,3,4,5 for the primary key then we should only populate 2,3,4,5 which are unique.how can we impement this scenario in datastage.

Regards,
Sagar

Hi All, We need to know that how can we join two XML's in a job which are target file's in other jobs. The scenario is like this in one job we are getting the address information based on client_id and writiing it to an XML file and in other job we are getting the phone information based on the clie...