-
Does DataStage work with byte stream, binary files
?A byte stream file was ftp'd from an HP3000 MPE/iX server to the ETL server (windows 2000). The column values are enclosed in double quotes (") and the spaces within these are not lost Comma (,) is the column delimiterHowever, the newline character is converted to binary (vertical rectangular box) and is not recognized as line (row) terminator either by notepad or the datastage sequential file stageSo...
-
-
-
-
-
Is it possible to create an outer join when I link the data from a HF to a transformer ?
I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer. From the very transformer, I need to take data from a hashed file so I create a link between the HF and the transformer. By default, the link is based on the equality of the 2 columns. But...
-
-
In SAP/R3, How do you declare and pass parameters in parallel job .
Want to convert Char to timestamp in transformer stage. Can anybody please tell me what conversion function I need to put in derivation?
-
-
-
MQ Series
Why and where and how is MQ series stage used in datastage?
-
-
Metdata Data Dependency
Explain how data dependency is studied using Metadata of Datastage?
-
Real-Time Data Integration
What is meant by real-time integration in terms of datastage and how is different from the same in Informatica.Explain batch and real time processing capabilities of both ETL tools with their characteristic differences?
-
Target Size
What is the normal size of data warehouse in a project?
-
Rate Routing & Standard routing difference
Can anybody tell in detail why we use Rate Routing in Repetitive Mfg. instead Normal Standard Routing?
-
How to use change capture stage in scds
Could any one please explain me how can we use change capture stage for scd1,2,3 types?
-
Unknown transformer variable definition
I can see the names of newly defined variables in the transformer stage property, but I cannot see the definition and the logic under it. Is it normal? Where can I find the definition of the stage variables?
-
Transformer stage Compilation Error in Ascential Datastage 7.5, Windows XP
Hi,
I have installed the datastage 7.5 in XP operating system, also installed visual studio .net 2008 for c++ compiler. But when trying to compile the datastage job which contain the transformer stage, I am unable to compile.
Below warning I am getting:
Warning: the PWD
environment variable is not defined. Remote process start up may be
unsuccessful as... -
DataStage Interview Questions
Ans