-
Could any one please tell me how informatica behaves in the following situation?(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E0) , 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))Where the following variables are decimalsA (Decimal(9,2)) = 2.0179896789716073791692725900792e-5B(Decimal(9,2)) = 99C(Decimal(9,2)) = 50D(Decimal(9,2))= 99E(Decimal(9,2))= 0F(Decimal(9,2))=2681.75Problem is that system is showing FAIL but expected to be PASS.How the systems behaves with exponent values?1) would informatica drops the exponent and takes 2 as 'A'2) takes exponent (A) as is (0.00%)
vamannam
- Apr 12th, 2010
I think you have to use below expressionIIF ( (A > (100 - B)),'FAIL', IIF( (C > (100 - D)),'FAIL', IIF((E<= F AND F>0), 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))))Regards,Vamsi
-
-
What are the main issues while working with flat files as source and as targets ?
Vani_AT
- Mar 28th, 2008
1. We can not use SQL override. We have to use transformations for all our requirements2. Testing the flat files is a very tedious job3. The file format (source/target definition) should match exactly...
rasmi
- Feb 6th, 2008
We need to specify correct path in the session , and mension either that file is 'direct' or 'indirect'. keep that file in exact path which you have specified in the session .-regards,rasmi
-
What is the difference between source definition database and source qualifier?
madhu.tella
- Mar 25th, 2010
Source definition in database is simply the table definition, but the source qulifier is one of the transformation in informaitca from which we can specify the data selection criteria to the database....
vemurisasidhar
- Sep 24th, 2007
A source definition database contain the datatypes that are used in the orginal database from which the source is extracted. where the source qualifier is used to convert the source definition datatypes to the informatica datatypes. which is easy to work with.
-
What are the locks with respect to mappings?How do you manually lock or unlock the mappings for chages?
ramachchandran
- Sep 14th, 2010
In Informatica locks are automatically created. to manually lock or unlock. Go to the admin console, select a repository and click the lock tab. using that you can create lock and release lock if al...
Pandit
- Oct 18th, 2007
If your PowerCenter repository is version-enabled, then you need to check-out /check-in in order to modify any objects (incl.. mappings). This is how you do the version control and locking on objects...!
-
Would you recommend using an orderby clause as part of a lookup sql override for a cached lookup data set in informatica
vemurisasidhar
- Sep 26th, 2007
if u use order by clause in the lookup it improves the performance. because system generated order by consists all the lookup ports in the orderby clause. instood use ur own order by clause. so that the input data can be sorted by the way u likeex. order by deptno--
chandrarekha
- Sep 24th, 2007
No ,It decreses the performance
-
Repository has been shutdown error
[09/23/2007 11:34:53] (Alert) Repository gowtham has been shutdown. I am getting error like this in services informatica repository server is starting but informatica is not starting pls help in this thanks and regards gowtham
prasad1507
- Dec 11th, 2007
Please check whether u have correct user privilege in windows to start services. You should have service start privilege in windows. One more thing Informatica server will be started and alive only any workflow is created.If this doesnt help, come back with exact details of your problem
vemurisasidhar
- Sep 26th, 2007
i think u need to restart tje services again. before that check all the configurations. like repserver,server,repository admin management console.
-
What is the difference between Session task and Command task?
gen ganesh
- Feb 15th, 2018
Session is one of the task. Task may be session, shell command or email task. When we create task there will be drop down which task should be created. A session is a type of task, similar to other ...
sarita.harsh
- Mar 12th, 2009
Session task: A session task is associated with a mapping. It helps in running the mapping. We need to specify the source and target connections etc in the Mapping tab and configure the properties a...
-
How do we Kill process if the process is running?
Do we have any specific number which we have to use with kill command?
nitin_2002786
- Jan 24th, 2013
U can use
ps -ef | grep USERID
where USERID is the Id with which the process is running.
It will give you output with two Id and detail of process name
kill PID
or
Kill -9 PID (if kill does not work )priyank_divya
- Jul 9th, 2012
If its an Unix installation, we can use the below commands:
ps_ef --> To know the processes running in backend.
kill -9 --> to kill a process forcefully. -
Can we Use PACKAGES in Informatica mapping?if yes, How?
nandu214
- Jun 17th, 2008
Yes same as store procedure and one advantage of packages is it has overriding facility for this first we create package and store it in database before running the mapping
Kadhirvelu
- May 12th, 2008
Hi,what kind of packages ? are you talking about Oracle PL/SQL packages, the answer is yes. In fact, you can use Stored Procedures, Stored functions. And in the same way, you can use Packages.
-
Repository deletion
what happens when a repository is deleted?If it is deleted for some time and if we want to delete it permanently?where is stored (address of the file)
sandeep_sajjan
- Dec 3rd, 2007
repository is stored in database ,go in repository admin console right click on repository then choose delete . a dialog box is displayed fill up the user name(database user wr ur repository is ...
chandrarekha
- Nov 29th, 2007
I too want to know the answer for this questionI tried to delete the repository ,that time it was deleted after that i tried to create the repository with the same name what i was deleted earliar , it...
-
How do you join the table if there is no relation ship
question was asked from accenture and Wipro.
vamannam
- Apr 12th, 2010
The main aim of your question is that you have to load the both table’s data in to your target table with joining of the two tables even if you don’t have a common column to join both tabl...
sridhar.gonda
- Oct 27th, 2007
U hav to create a dummy common column in both tables thn u can join both tables.
-
How can we capture rapidly changing data?
arunkumarengg
- Nov 23rd, 2007
By using CDC (changing Data capture)
-
How can we calculate the fact table size?
nandu214
- Jun 17th, 2008
Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.Ex:- if we have 100...
-
What is the economic comparision of all the Informatica versions?
ggazulas
- May 27th, 2008
Economic comparision is nothing but the price-tag of informatica available versions.
-
What are tracing levels in transformation?
prabhat007
- Dec 8th, 2007
Tracing level in the case of informatica specifies the level of detail of information that can be recorded in the session log file while executing the workflow.4 types of tracing levels supported1.Nor...
Abhishek Shukla
- Nov 19th, 2007
Tracing level keeps the information aboaut your mapping and transformation.there are 4 kind of tracing level which is responsible for giving more information on basis of their characterictis.ThanksAbhishek Shukla
-
What is the use of Shared Folder?
toSudharsan
- Jun 9th, 2009
Shared Folder is like another folder but that can be accessed by all the users(Access can be changed), This is mainly used to share the Objects between the folders for resuablity. For example you can ...
Ram
- Nov 23rd, 2007
The Objects stored in the shared folder can be shared by the global users.I mean we can restrict one user not to access the contents of the folder by the priviliges of the folder.
-
Why cant we use more than two groups connecting the target in router transformation?
Amritendra kumar
- Feb 29th, 2008
My dear we can use more than two group in router transformation. it is the main purpose of router to define many condition. there is one default output also so if you are giving 4 condition there than output will be 5. and for this we need 5 target.hope it will help.thanks
sekhar.ganta
- Jan 3rd, 2008
we can use more than two groups connection the target . If you take emp table, for this we we have to take 3 targets,for the purpose of If sal
-
Informatica primary server process
Which is primary server process in informatica?1.repository manager 2.load manager 3.workflow manager 4.workflow designer
alex
- Apr 29th, 2013
Load manager
suvashis
- Dec 12th, 2007
Hi.."load manager' is the primary process of informatica power center server"DTM-data transformation manager" is the secondary prcess..go through the architecture of informatica power center server..thank u...suvashis
-
Informatica union transformation
What is the practical use of a union transformation?
ask_kaushik
- Dec 6th, 2007
That was the description....practical use would be like : if you have 3 different sources which returns different number of records but with the same ports and datatypes, union transformation can be used to sum up these records and proceed to the next transformation as the same pipeline.
ask_kaushik
- Dec 6th, 2007
The Union transformation is a multiple input group transformation that you use to merge data from multiple pipelines or pipeline branches into one pipeline branch. It merges data from multiple sources...
Informatica Interview Questions
Ans