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