-
How to import .xls format file using informatica
How to import a .xls as source into informatica.I want to import the data from two columns of a .xls sheet.
greatvaiz
- Jul 19th, 2008
1. Go to excel you wnat to inport and select the area where the data is present.2. Go to insert,name,define and define the area3. Create ODBC for excel file.4. Using the created ODBC select the to exa...
Noel Lastra
- Feb 26th, 2007
Hi there!Just want to add some... you can use content master and tgp to convert the xls file to xml file. then you can use UDO transformation, XML Parser transformation. Basically the objective here is to convert the XLS file to XML.
-
-
What are the questions asked in PDM Round(Final Hr round)
srinuv_11
- Nov 14th, 2006
We can't say which questions asking in which round that will depending on the interviewer. In Hr round they will ask what about ur current company, tell some thing about ur company and why ...
-
Why we use stored procedure transformation?
For populating and maintaining data bases.
bneha15
- Apr 18th, 2007
We use a stored procedure transformation to execute a stored procedure which in turn might do the above things in a database and more.
-
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.
-
Folder Access
Same machine is using more than one user at different time, how to identify whether an particular user used a folder or not
varma.dantuluri
- Jul 9th, 2008
You can check out this options in Repository Manager.Open the Edit tab and select the option Show User Connections where you can find the information related to the users , connection_id and the ...
-
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.
-
What is the impact of versioning for an Informatica repository?
What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah
adilshariff
- Jul 1st, 2008
1.Versioning is a one time and one way process on Informatica repository.2.No impact on both the exisitng and new reprository.Infact Versioning is advantage,it is help full in team based envirno...
Uma Bojja
- Aug 14th, 2007
Versioning on repository is irreversible. Once we choose to version its done.Let me know which version of informatica are you using.ThanksUma Bojja
-
Repository Backup
What is the extension used to store backup of repository?
-
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...
-
Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
prade
- Jun 26th, 2008
In case of a source based commit, the integration services generates a commit row from the active sources and writes the rows into the target. The number of rows processed from the "active source...
vivek1708
- May 11th, 2008
I dont think above written statement is correctMyunderstanding is that for source based commit: a session as soon as it reads 10k rows from the source it performs a commitand similarly for tbc: as soon as it write 10k rows to targt it does a commit
-
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?
NO.Unless and until u join those three ports in source qualifier u cannot map them directly.
prade
- Jun 26th, 2008
Sources from heterogenous databases cannot be pulled into a single source qualifier. They can only be joined using a joiner. And then can be written to the target
Vani_AT
- Apr 2nd, 2008
I don't think dragging three heterogeneous sources in a single source qualifier is valid. Whenever we drag multiple sources in same source qualifier, 1. There must be a joining key between the tab...
-
In a sequential batch can u run the session if previous session fails?
Yes.By setting the option always runs the session.
prade
- Jun 26th, 2008
Yes you can. Start ---L1-------> S1 --------L2-------> S2suppose S1 fails and we still want to run S2, then L2 condition --> $S1.status = FAILED or $S1.status = SUCCEEDED
-
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.
-
How to use incremental loading when you load data from staging?
nandu214
- Jun 17th, 2008
HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps
-
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...
-
How to run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?
-
Delete Informatica repository
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
hasim_geek
- Jun 6th, 2008
To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager.
-
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.
-
In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?
ggazulas
- May 27th, 2008
You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table. But remember we are refering to the same table in dynamic chache, so if it is inserted in the cha...
prakash
- Nov 26th, 2007
Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup
Informatica Interview Questions
Ans