Hi All,
I have some problem during use of Map Designer.
For Ex: I have dimension tables called Employee(Empid,Empname) and Department(DeptID,DeptName) in datawarehouse,one source table which contain columns from Employee and Department as well as additional of it's own.I have target table which is a staging area which contain columns from source table and some boolean value columns.for example(empname_bit,deptname_bit)I want to extract the value into this target columns as either 0 or 1,here the condition is that if Empname of source is exist into the Employee dimension table then value in Empname_bit should be load as 1 and if not then value should be 0,So i wanted to confirm whether we can do this kind of transformation at row level or at DB level in Map Designer.
Thanks in Advance.
Problem during mapping
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Problem during mapping
IBM Websphere Datastage Certified Professional
..........
You should be able to handle this.
I used to have a system where;
A nurse fills out a form, including an ID field, and sends the info as a Word Document. A VB program saves it as text file, and my system gets it.
I do a DB look up to a table, DBLOOKUP() , to see if the nurses ID is present. If it is NOT, I check another table. If it IS in the second table, I put it in the first table. This was done all through one map with multiple output cards.
I run an SQL statment against the first table using the "DBLOOKUP()" function, then based on the value returned, I would go against the second table, etc.
It seems this is what you want to do;
IF( DBLOOKUP(SQL STATMENT) > "", 0, 1) (Greater then null)
I used to have a system where;
A nurse fills out a form, including an ID field, and sends the info as a Word Document. A VB program saves it as text file, and my system gets it.
I do a DB look up to a table, DBLOOKUP() , to see if the nurses ID is present. If it is NOT, I check another table. If it IS in the second table, I put it in the first table. This was done all through one map with multiple output cards.
I run an SQL statment against the first table using the "DBLOOKUP()" function, then based on the value returned, I would go against the second table, etc.
It seems this is what you want to do;
IF( DBLOOKUP(SQL STATMENT) > "", 0, 1) (Greater then null)
..........
You should be able to handle this.
I used to have a system where;
A nurse fills out a form, including an ID field, and sends the info as a Word Document. A VB program saves it as text file, and my system gets it.
I do a DB look up to a table, DBLOOKUP() , to see if the nurses ID is present. If it is NOT, I check another table. If it IS in the second table, I put it in the first table. This was done all through one map with multiple output cards.
I run an SQL statment against the first table using the "DBLOOKUP()" function, then based on the value returned, I would go against the second table, etc.
It seems this is what you want to do;
IF( DBLOOKUP(SQL STATMENT) > "", 0, 1) (Greater then null)
I used to have a system where;
A nurse fills out a form, including an ID field, and sends the info as a Word Document. A VB program saves it as text file, and my system gets it.
I do a DB look up to a table, DBLOOKUP() , to see if the nurses ID is present. If it is NOT, I check another table. If it IS in the second table, I put it in the first table. This was done all through one map with multiple output cards.
I run an SQL statment against the first table using the "DBLOOKUP()" function, then based on the value returned, I would go against the second table, etc.
It seems this is what you want to do;
IF( DBLOOKUP(SQL STATMENT) > "", 0, 1) (Greater then null)