Loading...
Uploaded by pmvrss on Jan 30, 2010
Creating a Mapping, Session, Workflow using Informatica Powercenter 8.6.1
Education
Standard YouTube License
I Recevied below error when map single source table to target:
SQL Error [Microsoft OLE DB Provider for SQL Server: Statement(s) could not be prepared.
SQL State: 42000 Native Error: 8180
State: 1 Severity: 16
SQL Server Message: Statement(s) could not be prepared.
Microsoft OLE DB Provider for SQL Server: Invalid object name 'SourceData'.
SQL State: 42S02 Native Error: 208
SQL Server Message: Invalid object name 'SourceData'.
isenthil123 7 months ago
@isenthil123 check if the table 'SourceData' exists in your database.
to debug more send me the session log file.
pmvrss 7 months ago
@isenthil123 make sure the table you are using in informatica mapping exists in the back end database.
pmvrss 6 months ago
Follow me on Twitter: Vam_27
pmvrss 8 months ago
Hi Vamsi,
Thanks for the demo, it helped me to start my ETL development.
rajeshmay16 9 months ago
@rajeshmay16 thanks for watching my videos. i am glad it helped you.
Thanks for demo
kamaleshpramanik 10 months ago
How different is Informatica 9 from Informatica 8.6?
AntiMessiah2023 11 months ago
Thanks for the video. It was really helpful...
informsapta 1 year ago
very helpful for informatica beginners. nice video.....
sivasarat189 1 year ago
Load more suggestions
I Recevied below error when map single source table to target:
SQL Error [Microsoft OLE DB Provider for SQL Server: Statement(s) could not be prepared.
SQL State: 42000 Native Error: 8180
State: 1 Severity: 16
SQL Server Message: Statement(s) could not be prepared.
Microsoft OLE DB Provider for SQL Server: Invalid object name 'SourceData'.
SQL State: 42S02 Native Error: 208
State: 1 Severity: 16
SQL Server Message: Invalid object name 'SourceData'.
isenthil123 7 months ago
@isenthil123 check if the table 'SourceData' exists in your database.
to debug more send me the session log file.
pmvrss 7 months ago
@isenthil123 make sure the table you are using in informatica mapping exists in the back end database.
pmvrss 6 months ago
Follow me on Twitter: Vam_27
pmvrss 8 months ago
Hi Vamsi,
Thanks for the demo, it helped me to start my ETL development.
rajeshmay16 9 months ago
@rajeshmay16 thanks for watching my videos. i am glad it helped you.
pmvrss 7 months ago