Relational connection

Hi friends,
I connect the pubs database and i move the data to the target successfully. but i connect the Northwind as the same procedure but the task is failed. I don't know what the fault is this? Anyone answer this question please....

Questions by Rocksakthi   answers by Rocksakthi

Showing Answers 1 - 3 of 3 Answers

savitha1

  • Jul 14th, 2008
 

hey Go to workflow manager, from Connection menu-  select Relational option and configure for Northwind giving the database nmae as Northwind.

Once that is done..for the session created..double click the session and in mapping tab - select the source and change the configuration from pubs to Northwind.

Hope I answered ur question.

Rocksakthi

  • Jul 24th, 2008
 

Thank you very much for your reply savitha. but i already solve the problem. the problem is informatica cannot accept the space in the table name and field name but in the nothwind database if you import Order details table it wil shows in the soruce analyzer Like this Order_details but if you do mapping and run the task means it will show the session failed message. so i removed the space and the problem solved. please give solution me this question. For using the Unconnected Look up we should give expression in the Expression transformation. would you please tell me what is that expression?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions