-
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 sessions
What is the difference between a session and a task?
dl_mstr
- Feb 8th, 2008
Seesions : Set of instructions to run a mappingTask: session is type of task. other than that informatica several type of task like Assignment,Command,Control,Decision,Email,Event-Raise,Event-Wait,Timer,session
-
Aggregator transformation
How does sorted input works in aggregator transformation
gaurav2485
- Jan 8th, 2009
Plus when Source data is data driven then Sorted won't effect Performance of aggregator
Vani_AT
- Dec 28th, 2007
Aggregator transformation performance can be improved by using the sorted input option. When you use sorted input, the PC Server assumes all data is sorted by group. As the PC Server reads rows f...
-
Parameter file
How to create parameter file and how to use it in a mapping explain with example
gaurav2485
- Jan 8th, 2009
Suppose we have certain variable or parameter whoes value which change frequently so we will change that value in Parameter file( it is more feasible as no change in Mapping)
sivavin1
- Dec 28th, 2007
Please place your parameter file in the server "srcfiles" with data in it.In mapping designer window of powercenter designer,click on "Mapping" and then "Parameter and variabl...
-
External procedure transformation and Custom transformation
What is the difference between "external procedure transformation" and "custom transformation"?
sarita.harsh
- Mar 4th, 2009
The input and output functions occur separately in Custom Transformation. In External transformation both input and output? are done by the external procedure function and its parameter consist of a...
phdsong
- Aug 6th, 2008
Both transformations operate in conjunction with procedure your create outside of the Desinger interface to extend PowerCenter functionality. However, for external procedure transformation, you need t...
-
Use of Aggregator Transformation
In source qualifier transformation we can writer customer query. That means we can do aggregator calculations also. So what is the need of Aggregator Transformation?
Mamta11
- Jul 26th, 2008
What if you want to aggregate the data down the pipeline (after manipulating the source data). This is where you require aggregate transformation.
ravi_se2000
- Jan 16th, 2008
Sourcequalifier transformation filters rows when it reads the souce data from the PowerCenter Server if you give any filter condition, but Aggregator transformation is used for multiple filter conditi...
-
Migration of mappings
How do we move mappings from development environment to Testing environment and from there to production?
Noel Lastra
- Mar 5th, 2008
Export your mappings into XML, place it in your local folder then go the next environment and import the xml mappings you've exported.
pal.amol
- Feb 26th, 2008
Dear Friend,Migration of mappings are very delicate things. In this process you need to take backup of repository if it is test to QA and from QA to Production as you mentioned.Follow on i would like ...
-
Session variables - what are they exactly
What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .
harikr
- Dec 7th, 2009
Parameters and variables are not the same.Parameter is one whose value remains the same throughout a session. You can set an initial value/default value.Variable is one whose value changes through the session. You can perform some functions such as MAX or MIN on the variables.
gaurav2485
- Jan 8th, 2009
Yes they are same , But suppose if we define Same variable in Session and mapping with some value then Informatica will take Value which has been defined in Session
-
Failed Workflow
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps to run the workflow.
vivek1708
- Jul 29th, 2008
As u wish to run the workflow frm the second session, just go to workflow manager,right click on the session that u wish the begin the sequence from and click on 'start workflow from task'
garunchowdary
- Feb 29th, 2008
If you configure a session in a sequential batch to stop on failure,you can run recovery starting with the failed session.The Infomatica server completes the session and then runs the rest of the batc...
-
ETL Tool Complete Process in Informatica
What is the complete process in Informatica power center client tool? Explain using ETL tool
vijaykumar2009
- Dec 9th, 2009
ETL complete process done as fallows: In INFORMATICA POWER CENTER DESIGNER Creation of source table Creation of target table Creation of mapping :plan of implement business logic &nbs...
DK_Reddy
- Apr 19th, 2009
ETL-Extraction (from Source)-Transformation-Loading (to Target)In this process There are 2 servers active at the same time 1) Informatica Server. 2) Repository ServerHere Informatica Server Connec...
Informatica Interview Questions
Ans