regarding merge stage

vijaykumar · Post by **vijaykumar** » Tue Jan 16, 2007 4:46 pm

Hi,

my design is MERGE----->ODBC.

using merge stage iam merging 2 sequential files and dumping into database.
i have declared the path of the sequential files as parameter.

FIRST FILE DIRECTORY PATH: #$PATH_FILE#
SECOND FILE DIRECTORY PATH: #$PATH_FILE1#
I specified the first filename: vijay----> the name of the first sequential file.
second filename:salma---->name of the sequential file.
join type---->pure inner join.
input file formats---->first name is the column names.
input column names---> specified the columns.
first file column key--->DEPTNO
second file column Key---->DEPTNO since deptno is column key.
I mapped all the columns from left side to right side, i mapped only deptno from only one sequential file, when i try to map depno from another sequentail file, it says deptno already exists.

please help me Gurus, its compiling but its failing, iam getting LINK RETRIEVAL ERROR.

please help me gurus.

cheers;
vijay

vijaykumar · Post by **vijaykumar** » Tue Jan 16, 2007 5:37 pm

Hi Gurus,

My sequential file location is c:\HashFiles\salma

where salma is the name of the sequential file

Another sequential file location is c:\Hashfiles\hash\vijay

where vijay is the name of the another sequential file.

when dealing with merge stage.
First file directory path: c:\HashFiles

second file directory path: c:\ Hashfiles\hash
In the first file name i specified
c:\HashFiles\salma
second file name i specified
c:\Hashfiles\hash\vijay.
iam getting error- cannot open input file, cannot retrieve link properties.

Please help me Gurus.

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 16, 2007 5:43 pm

You cannot add columns with the same name into column list.
When you try to drag a column with the same name it complains and asks you to specify a differet name. Give a different name.
You should be fine.

kumar_s · Post by **kumar_s** » Tue Jan 16, 2007 5:58 pm

Hi Vijay,
Check for the filename and path name. Copy and type for the same value that you had given in the link information.
narasimha - Drag drop functionality is not available in Server Merge stage.

narasimha · Post by **narasimha** » Tue Jan 16, 2007 6:06 pm

kumar_s wrote:narasimha - Drag drop functionality is not available in Server Merge stage.

Kumar,

I am pretty sure Drag drop functionality exists in Server Merge stage. In fact I double checked it now.

kumar_s · Post by **kumar_s** » Tue Jan 16, 2007 6:09 pm

narasimha wrote:
kumar_s wrote:narasimha - Drag drop functionality is not available in Server Merge stage.
Kumar,

I am pretty sure Drag drop functionality exists in Server Merge stage. In fact I double checked it now.

Oh Iam sorry.. then I should be missing it.

vijaykumar · Post by **vijaykumar** » Tue Jan 16, 2007 6:11 pm

Hi Gurus,
Still iam getting error, cannot open file1.Please help me Gurus.

cheers;
vijay

us1aslam1us · Post by **us1aslam1us** » Tue Jan 16, 2007 6:15 pm

Is that a Hashed file you are trying to access or a sequential file???

Make sure the directory paths are correct.

narasimha · Post by **narasimha** » Tue Jan 16, 2007 6:26 pm

vijaykumar wrote:Hi Gurus,
Still iam getting error, cannot open file1.Please help me Gurus.

cheers;
vijay

Did the solution I gave earlier, solve the " LINK RETRIEVAL ERROR" ?
When do you get the "cannot open file1." error?

Saama · Post by **Saama** » Tue Jan 16, 2007 6:38 pm

Hi Gurus,

Every thing is working fine. Drag and drop functionality is present.
Its not reading the data from my sequential files.

Actually my designs are

ODBC----->TRANSFORMER----->SEQUENTIAL FILE1
ODBC----->TRANSFORMER------>SEQUENTIAL FILE2
i have dumped the data from odbc into sequential file 1 , i have dumped employee table in seq file1, then i have dumped DEPT table into sequential file2, Now iam merging 2 sequential files using merge stage.
I wanted to view the data from merge stage, the icon is inactive, i can't view the data.
when i went to director to view log message, i can't find any error message.
please help me , why my merge o/p is empty.

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 16, 2007 6:56 pm

Saama wrote:I wanted to view the data from merge stage, the icon is inactive, i can't view the data.
when i went to director to view log message, i can't find any error message.
please help me , why my merge o/p is empty.

cheers;
vijay

You cannot view the data from the Merge Stage.
You need to connect the output of your Merge stage to an output say a sequential file.
You will be able to view your merged data there.

Saama · Post by **Saama** » Tue Jan 16, 2007 7:09 pm

Hi,

My design is MERGE----->SEQUENTIAL FILE.

Iam getting the datasource is empty.

Even on the link i can see 0 rows/sec.

That means its not reading the data from my sequential file.

please help me Gurus .

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 16, 2007 7:18 pm

Not sure, where you are going wrong.
You have used a Pure Inner Join which merges only those rows with the same key values in both input files.
Check your Join Type condition. Does it satisfy your criteria?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 16, 2007 8:01 pm

Please post the first couple of lines from each of the input files. Please also verify that these are true text files, not hashed files.

vijaykumar · Post by **vijaykumar** » Tue Jan 16, 2007 10:04 pm

Hi Gurus,
I was using the join type incorrect.But Now its ok, when i run this job,
iam getting these error,please help me Gurus.

..Sequential_File_1.IDENT1: At row 2, link "DSLink4", while processing column "DEPTNO1"
Value treated as NULL
Attempt to convert String value "MGR" to Double type unsuccessful.
Attempt to convert String value "COMM" to Double type unsuccessful.
dileep1..Sequential_File_1.IDENT1: Function 'get_next_output_row' failed
At row 4, link "DSLink4", while processing column "DEPTNO1"
Column value must be non NULL.

please help me Gurus.
cheers;
vijay