While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?
Latest Answer: You can use excel file as input by importing the .xls file.step1 --> Go to Administrative Tools -> Data Source (ODBC) --> System DSN. Click on Add button and configure the corresponding .xsl file in your system DSN. Make sure that workbook contains ...
How can I identify the duplicate rows in a seq or comma delimited file?the case is...> the source has 4 values like, agent id, agent name, etc... our requirement is that the ID shouldn't be repeated. so how can i identify the duplicate rows , set a flag and send the rejects to the specified reject file? the source systems data is directly given to us. tha's why we are getting these duplicates.if it has a primary key set up already then it would have been very easy.thanks in advance.
We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage
I am new to DataStage can we need to load a excel file which has both ARABIC and ENGLISH text. Here my source id IBM DB2. If I want to display the Arabic content in my browser I need to store it in the UNICODE format in the Database. Can any one tell how to store the content in a excel file as UNICODE NLS . In DataStage the option has been provided only for Sequential files.Thanks in advance.Regards,Kris.
To pass parameters to the job we can use Unix shell program. But I do not know exactly how to do that.Plz let me know detail steps to pass the parameter through shell script
I am trying to execute batch file which has dsjob command to run data stage job from CLI.I am getting error code = 81011 (project not found but project is there)But I can run other jobs. I am getting into problem for one particular batch.any help
Latest Answer: what type of error dud you got.explain error. ...
Can a sequential file stage can read the path from other sequential file. in which the data is stored
Latest Answer: two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...
View page << Previous 9 10 11 12 [13] 14 Next >>
Go Top
