Common Error Part1

These are errors which i encountered working today..I have put solution for them with detailsError :  Scheduling Error for workflow, workflow [id = X] could not be retrieved from the repositoryReason : Your workflow and related object are not checked inSolution : Checkin workflow and related objectsError :  Schedule Workflow: ERROR: Workflow [wf_name]: Workflow not scheduledReason :   Your are using resuable scheduler and it is not checked inSolution :  Checkin resuable schedulerError :  Input sources to SQ SQ_TRADE have...

Read More

How to change the mapping associated in the session:

Often during development cycle we come across scenario when you have to change session’s existing mapping with a new one.Informatica should have provided a direct option to choose new mapping unfortunately it is not straight forward you can follow below method to achieve this 1. Invalidate the current mapping temporarily and refresh the session. This would allow you to choose a different mapping for your session. Pick the new one.2. XML export. Export the session object and then edit the xml file where you need to change the mapping name. Now when...

Read More

How to pass a mapping value of mapping variable to workflow and worklet

Normally we come across various scenarios where have to use value from inside of mapping as session or workflow/worlklet variable.Two scenarios I can think of 1.       You have to use sessstarttime in sending attached files by email in email task. You can’t do it normally as sessstart time is not available in email task.2.       You have a mapping to capture errors in mapping and you...

Read More

informatica

Informatica Scenario based interview questions (Convert row into columns) This is the one of most frequently asked informatica scenario based interview question We have source data like below in table A B C Output required is A B C I have seen rarely a candidate answer this question correctly. Their answer is mostly a crammed (by reading on various website) without understanding...

Read More

Informatica Scenario based interview questions (Convert columns into rows)

This is the one of most frequently asked informatica scenario based interview question.We have source data like below in table A B C Output required is A B C I have seen rarely a candidate answer this question correctly. Their answer is mostly a crammed (by reading on various website) without understanding core concept of informatica transformations.I will explain three methods to achieve this then we will find out which one is best method...

Read More

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 itScenario :Create a mapping with two streams( one with Transaction control and Second without Transaction control)..You will get  above errorSrc1 - SQ1- EXP1- TGT1Src2 - SQ2- Exp2-TC-TGT2Reason :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...

Read More

Issue with informatica client in Dual Monitor

ProblemRecently i started with informatica in dual monitor and found few issues (Like Expression editor size and sq editor getting greyed out)SolutionAt 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\SQLChange the values of the following to 0Expression Editor PositionExpression Editor Splitter PositionSQL Editor PositionSQL Editor Splitter PositionPlease restart your pc after changing...

Read More