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
Search found 25 matches
- Wed Nov 18, 2015 10:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scenario in Datastage
- Replies: 2
- Views: 2407
- Fri Oct 09, 2015 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic to perform
- Replies: 5
- Views: 4334
- Fri Oct 09, 2015 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic to perform
- Replies: 5
- Views: 4334
Required logic to perform
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
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
- Wed May 27, 2015 2:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: cast function in db2
- Replies: 3
- Views: 2727
cast function in db2
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.
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.
- Tue Feb 17, 2015 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic for a scenario
- Replies: 12
- Views: 7205
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...
- Mon Feb 16, 2015 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic for a scenario
- Replies: 12
- Views: 7205
- Mon Feb 16, 2015 11:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic for a scenario
- Replies: 12
- Views: 7205
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 ...
- Mon Feb 16, 2015 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required logic for a scenario
- Replies: 12
- Views: 7205
Required logic for a scenario
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...
- Wed May 14, 2014 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to SQL server using windows authentication
- Replies: 2
- Views: 1697
- Wed May 14, 2014 2:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to SQL server using windows authentication
- Replies: 2
- Views: 1697
Connecting to SQL server using windows authentication
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.
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.
- Mon Oct 01, 2012 11:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC connection not able to connect in datastage
- Replies: 1
- Views: 2278
ODBC connection not able to connect in datastage
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
- Thu Dec 17, 2009 12:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to delete temporary datasets after jobs get completed
- Replies: 3
- Views: 2412
Need to delete temporary datasets after jobs get completed
Hi,
Need to know the script for deleting temporary datasets created after sucessful completion of the jobs.
Need to know the script for deleting temporary datasets created after sucessful completion of the jobs.
- Thu Dec 03, 2009 5:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get only unique records
- Replies: 7
- Views: 3715
- Thu Dec 03, 2009 5:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get only unique records
- Replies: 7
- Views: 3715
To get only unique records
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
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
- Mon Oct 12, 2009 5:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join of XML's in datastage
- Replies: 1
- Views: 2629
Join of XML's in datastage
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...