This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Showing posts with label Informatica common errors. Show all posts
Showing posts with label Informatica common errors. Show all posts

Wednesday, 12 March 2014

Common Error Part1

These are errors which i encountered working today..I have put solution for them with details

Error :  Scheduling Error for workflow, workflow [id = X] could not be retrieved from the repository
Reason : Your workflow and related object are not checked in
Solution : Checkin workflow and related objects


Error :  Schedule Workflow: ERROR: Workflow [wf_name]: Workflow not scheduled
Reason :   Your are using resuable scheduler and it is not checked in
Solution :  Checkin resuable scheduler

Error :  Input sources to SQ SQ_TRADE have no relationship....there are data flow validation errors.
Reason : Created Source qualifier by manually dragging item from diffrent source but sql override provide
Solution : Over rid the SQL query in source qualifier

Tuesday, 25 February 2014

Informatica Common Errors :The Target Definition has more than one Transaction Control point connected to it

Error : The Target Definition has more than one Transaction Control point connected to it

Scenario :


Create a mapping with two streams( one with Transaction control and Second without Transaction control)..You will get  above error

Src1 - SQ1- EXP1- TGT1

Src2 - SQ2- Exp2-TC-TGT2

Reason :

Informatica processes transactional data row wise, hence,while using Transaction control for one of the targets to define the transaction point, Informatica fails to identify the transaction point for the other targets,This results in "The Target Definition has more than one Transaction Control point connected to it".

Solution :

You need to define Transaction Control transformation in other pipeline with property TC_CONTINUE_TRANSATION.

Friday, 14 February 2014

Issue with informatica client in Dual Monitor

Problem

Recently i started with informatica in dual monitor and found few issues (Like Expression editor size and sq editor getting greyed out)

Solution

At commend prompt type regedit and  go to below path (Please take backup of registry before making any changes)

HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Editor\SQL

Change the values of the following to 0

Expression Editor Position
Expression Editor Splitter Position
SQL Editor Position
SQL Editor Splitter Position

Please restart your pc after changing the registry values.

Hope it helps to solve your issue.