DSXchange

Hi Chulett,

As I have mentioned earlier that we are using Windows and not UNIX(we cannot use cat function).

Is there any way to concatenate all of them into one large file using Datastage 7.5 Server job.

Will the folder stage does this?



Thanks
Kiran

Hi We had requirement to read from 6000 text files(.txt) and load them into single Oracle table. We dont take any consideration of the format of the file(directly dump into oracle table).The output oracle table has only one column. for example : Input : The test1.txt has 2 rows. 01*WOLAS*350-1*OBC-S...

Thanks. We wanted to know if there is any work around to use Salesforece Pack even though we have installed Server edition. Since we are planning to replace the current approach(i.e using Informatica for extracting from Salesforce.com) with that of Infosphere Salesforce Pack,Is it compulsory we need...

Hi We are using Infosphere 8.5 server edtion on Windows 2008 R2.There is a new requirement for us to extract data from Salesforce.com and load into the tables in our environment.(which informatica is doing currently). We had downloaded the Salesforce pack from IBM website and we had installed it on ...

Terminators in the final column must be Quoted to be recognized as data, meaning inside the quoted string that is the final column's data. ... Hi Chulett, I didnot get exactly what you meant by "Terminators in the final column must be Quoted". Firstly my input data to the sequential file ...

Can your please elaborate? As you told, the new line character is there in the last field. then what about the record delimiter? Can you please post your actual input data and mention what's your required output? Please find the below sample input, Name|EmpID|Description Ravi|001|This is Ravi Raj e...

Thanks Ray.

We are using LDAP in our scenario and this set up is suitable for our requirements.



Thanks
Kiran

Hi Chulett, Sorry for the late update on this.Actually it worked for us.I thought of updating this,so that it will be useful for others. Enabling the "Contains Terminators" to yes and applying Convert(CHAR(13):CHAR(10),"",YourField) in the transformer,it has handled newline chara...

Hi Ray,


Can you please provide any inputs on the above points we mentioned.



Thanks
Kiran

Hi Ray, Actually we had installed Infosphere Server 8.5v server edition on Windows 2008 server and we are not aware of AppServerAdmin script you have mentioned. What we did was : We had installed Infosphere Server 8.5v server edition on Windows 2008 server with a service account.(say "testadmin...

Thanks Ray, As mentioned by you,We had defined the default credentials(i.e primary administrative name defined in WAS) in Domain management :Engine credentials:Open configuration in Infosphere server web console Then,we just added the "test user" to AD group and we haven't mapped user cred...

Thanks Ray. We are not sure why we are unable to connect to Designer through "testuser" however this is part of AD group.we are able to connect only when we define "testuser" in Engine credentials in Domain management in Information server web console. Do you think any problem wi...

It is pointing to "Standalone LDAP registry" only in the Current realm definition, in the Global security tab in WAS console. Do you agree with the statement,it is not required to set up individual user (example "testuser" in this case or suppose 50 users) engine credentials in D...

Hi Ray,

Can you please provide any inputs on the above points we mentioned.



Thanks
Kiran

Hi Ray, Do you mean we haven't set up LDAP correctly in WAS admnistrator ?and hence do you think that is the reason "testuser" is not able to access Datastage designer even though "testuser" is part of DataStage Developers AD groups that are assigned required suite roles? How do ...