DSXchange

Hi Murari, I worked on this type of conversion: Input: ColA ColB ColC ColD 1 a b c 2 d e f output: ColA ColB ColX ColY 1 a ColC b 1 a ColD c 2 d ColC e 2 d ColD f In this job i have used a transformer stage for combining the Column names(ColC,ColD) and Column values(b,c,e,f) using a DELIMITER. And n...

Thanks Madhukar, here i am explaining my job in detail: a)First Input: Sequential File : Field 1 Field 2 Field 3 b)Second Input :Sequntial File : Filed 1 Field 2 Field 3 c)Comapre Stage : d)Output: Dataset Field1 values are differring in both the input tables. Here the output should contain the data...

A job containing 2 input files ,1 output file and 1 compare stage.while running this job i am getting error : "main_program: Fatal Error: Attempt to drop schema variable: "first.rec"; this may be due to dropping a subrec which contains a schema variable; this operation is not currentl...

What is the difference between the data set stage and sequential file stage?
up to where i know ,both of the stages can be loaded with the data formats like .CSV,.txt,and .dat.

so ,any one can help me on this....

Hi ,
while importing a file i am getting this erro,can any one help on this


Error:


error calling subroutine:DSR_nLS [Action=1];check DataStage is set up correctly in project development ;
the connection is broken[81002]]

What are active and passive stages available in datastage 8.0.1 version?(like,filter-active and expression-passive transformations in Informatica)

Hi,
i am also getting the same error while trying to view data in the target stage,can anybody suggest on this to avoid the error?


Simple Transformation:
Source-Sequential file (.CSV file)
Target-Dataset Stage