| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Relational connection
Answer: 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.... |
| July 07, 2008 05:18:53 |
#2 |
| Rocksakthi |
CRM Expert Member Since: March 2007 Total Comments: 2 |
RE: Relational connection
|
| 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? |
| |
Back To Question | |
