-
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...
-
Checksum and Pipeline
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
Mamta11
- Jul 26th, 2008
Pipeline in information means a series of transformation starting from one set of sources to a target set of targets.
subashreddy77
- Apr 27th, 2008
Hipipeline is the flow of data from source to target using some transformations(if required)tell me if u got what is check some and where it is usedif i was wrong please tell me where i am wrongbye nad take care
-
Significant change in Version 8 of informatica
Hi all,I would like to know what are the key differences between PowerCenter 7 vs 8? Give one significant change version 8 is offering?
vivek1708
- Jun 30th, 2008
I have worked with Informatica 7.1 but haven't used versioning.Informatica 8 is surely bundled with versioning systemAlso adding headers in a text target file is also possible in Info-8 without specifying the same while installation (which is wat you do for informatica 7)
sekhar.sanaka
- Apr 24th, 2008
Transformation wise we have some new transformations have been introduces like SQL Transformation,HTTP etc.we have file append mode has been introduced for the first time in informatica 8 for flatfile...
-
StartTask Command
Hi All,I want to ask about StartTask Command if i have 3 steps in the workflow and i want to ignore the first step and start workflow from step 2,so is the StartTask command will start Step2 then step3 or it is only start the step2
avneeshrathor
- Nov 3rd, 2009
Only start step2 task. For step 2 and step 3 both do "start workflow from this task".
N SRIRAM K
- Apr 14th, 2008
You can make the first step (session) disable and run the workflow..it runs all the sessions except the disabled...ThanksSRIRAM N
-
XML Source and Target
Hi I'm working on XML files using them as source and target,I never worked on XML before. Did anyone worked on XML? If so could you please help me,its little bit urgent. I want to know how to import XML source definition and target definition and changes to be done etc...Thanks in advance...Arun.
Rashmirekha
- Jul 9th, 2008
To import XML file as a source:1.To identify a source go to tools---> source analyzer2.From the sources menu option,select 'import xml file'. XML Wizard window will come.3.In the XML W...
hasim_geek
- Jun 6th, 2008
Check for the superb Informatica manuals "XML Guide" in your installation directory.
-
Transfer data from xls and ms-access to oracle
How we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible?
aniban
- May 10th, 2008
Both are very much possiblew/ INFA: Write a mapping with src as Excel (or Access) and tgt as Oracle. Note: if your Informatica server is on UNIX, you need to save the XLS as csv and use that.w/o ...
vivek1708
- May 8th, 2008
Ya this is possible. For higher versions of oracle 10g onwardsthis can be done in 2 ways1) without using informatica --MS excel - This can be directly imported into oracle --MS access - Us...
-
Informatica's connect for SAP R/3
How to connect Informatica's with SAP R/3?
anupama2000
- May 26th, 2008
It is due to wrong server connection, try to assign server correctly because the IP address what you are using may change, so try to resolve IP address in work flow manager -> assign server configuration.
anupama2000
- May 26th, 2008
The Lan connection might have changed or check the net8 configuration setup .
-
Using external procedures to extract data from COM objects
Hi, I have an application with integrated COM object. Need to extract some columns of data from that application. Can I use external procedure transformation and try to extract this data directly into INFORMATICA? Please elaborate.. Thanks in advance
ramakrishna.inf
- Jul 8th, 2009
No. Informatica does not extract data from application directly. It will extract only from databases and external sources.
-
Server will be disconnected
Hi, Every thing is fine .But my problem is in work flow monitor the server will be disconnected.Even thought both oracle and informatica are running
Rocksakthi
- Jul 5th, 2008
First you click my computer properties In the properties you click the computer name tab. IN the computer name tab you see the Full computer name that is your server name you should give that name (se...
hasim_geek
- Jun 6th, 2008
1/Check for your Machinename where your Informatica server service is running.2/check for the INformatica port in your Workflow manager is in Informatica server configuration.
-
How can use worklet variables and work flow variables
can any one tell me How can use worklet variables and work flow variables Regards Srinu
harikr
- Nov 19th, 2009
Regarding Usage, there is no difference between workflow and worklet variables.Worklet variables are used in worklets. Pre-Worklet Variable Assignment : You can assign the value of the workf...
-
Error Handling
How will you perform error handling in Informatica? What do you do with the bad files etc?
shr_4
- Oct 27th, 2010
Go to session log file and see no. of affected rows, applied rows and rejected rows. According to that you can know if any error occured. ?If any error occurs you can check why it occured and correct it accordingly.
Rajan Raorane
- Oct 21st, 2010
Use of Router Transformation and differentiate the bad file from the Required ones..hence further you can post the same in One Table
-
Target Load Order
Explain What is Target Load Order?
superhero
- Dec 5th, 2008
If you have two source qualifiers and two targets(eg:SQ1,SQ2 and TGT1,TGT2), to decide which target you need to load first, we are using this option.eg: if you want to load first tgt2 after that tgt1,...
prashastha
- Nov 12th, 2008
If you have a multiple sources connected with the multiple targets, then you can specify the order in which target loads data first.
-
Adding Values to a Column
How to add values to a column present in target file which column is not present in source file?
mythili.ki
- Jul 27th, 2009
Create a port in expression transformation and do calculation whatever you need for the target or assign default value for that port and just pass that to target.
jayanthidinesh
- Jan 7th, 2009
If the target column is coming as NULL value from source, You can give a default value by adding a column in expression transformation ad below.COLUMN_NAME (The datatype and value filed will populate....
-
DTM Buffer Size Default Buffer Blocksize
What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.
gaurav2485
- Jan 8th, 2009
DTM buffer size is memory you allocate?to DTM process (12 MB)Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)And Informatica...
calltomadhu
- Dec 31st, 2008
Hey,workflow manage allocate default of 12MB size to session. you can increase this according to you requirement by specifying them in the form of bytes or you can set to AUTO it will take accordingly...
-
Find Special Character in Flat File
How to find whether special character is present in flat file's data using Informatica as a ETL tool
janardhanpala
- Jun 14th, 2010
If you want find special symbol in flat file when you are importing from file at that time you can set delimeter -check the option- other and you can type symbol which is in your flat file.
nandagiripradeep
- Jan 25th, 2009
There would be a code page present in the properties of the source definition in case of a flat file. Such as LATIN, WESTERN EUROPEAN. We need to choose proper page code to identify the special characters in flat file.
-
Turn Off Version
What happens if you turn off version?
sppavankumar
- Jun 9th, 2009
You would not be able to track the changes done to the respective mappings/sessions/workflows.
-
Informatica Production Support Member
What is the responsibility of a Informatica production support member?
Senthilkrishnan
- Nov 16th, 2009
1) Have to monitor the scheduled jobs or run the workflows and scripts which needs to run the day.2) If any issues or job fails, Immediately check the logs and contact with support team if needed. Fre...
DK_Reddy
- Apr 26th, 2009
Production support means, whenever a problem/Error rises while the product is running we have to identify that problem/Error and solve it, or intimate about that problem/Error to the concern perso...
-
Target Data Loading
How & Where will you can see data loading in targets dynamically?
sharmahariom
- Jan 18th, 2010
You can use Power Center Monitor. Once you will open property window in monitor you can see dynamic data loading there.
vens28
- Apr 28th, 2009
We can check the target recorded loaded dynamically? by validating the query on target records with time period.1) We need to run the target records related query for? first load with time period an...
-
Dependency Problems
What are the possible dependency problems while running session?
ashrita
- Oct 8th, 2009
Dependency problems means when we run a process, the process output is input to other process. Then first process is stopped then it causes problem or stop running?other process. One process is depen...
gazulas
- Apr 22nd, 2009
Hey, quation is not clear, any how,,Dependency for workflow will always be (sessions and mappings)session will always be (mappings) mappings will always be (transformations)
Informatica Interview Questions
Ans