Informatica - Relational connection

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 628 of 630

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....

Total Answers and Comments: 3

Last Update: July 29, 2008 Asked by: Rocksakthi

Sponsored Links

Best Rated Answer

—

Submitted by: savitha1

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.

Above answer was rated as good by the following members:
Rocksakthi

July 14, 2008 05:35:14

savitha1

Member Since: July 2008 Contribution: 2

RE: Relational connection

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 24, 2008 05:18:53

Rocksakthi

Member Since: March 2007 Contribution: 4

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?

Is this answer useful? Yes | No

July 29, 2008 15:11:07

vivek1708

Member Since: May 2008 Contribution: 18

RE: Relational connection

Use :LKP.transformation_name(column1,col2,...)

Is this answer useful? Yes | No

Go To Top