regarding merge stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
regarding merge stage
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
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
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 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
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
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.
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.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
Kumar,kumar_s wrote:narasimha - Drag drop functionality is not available in Server Merge stage.
I am pretty sure Drag drop functionality exists in Server Merge stage. In fact I double checked it now.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
Oh Iam sorry.. then I should be missing it.narasimha wrote:Kumar,kumar_s wrote:narasimha - Drag drop functionality is not available in Server Merge stage.
I am pretty sure Drag drop functionality exists in Server Merge stage. In fact I double checked it now.
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Did the solution I gave earlier, solve the " LINK RETRIEVAL ERROR" ?vijaykumar wrote:Hi Gurus,
Still iam getting error, cannot open file1.Please help me Gurus.
cheers;
vijay
When do you get the "cannot open file1." error?
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
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
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
You cannot view the data from the Merge Stage.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 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.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
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?
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?
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 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
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