-
Load data from a pdf to a table using informatica.
Can we load data from a pdf to a table using informatica.
adilshariff
- Sep 16th, 2008
Yes, you can load data from a pdf to a table using UDO[Unstructured Data Option] Transformation in Informatica from PC811 onwards
balajirajd
- Jul 26th, 2008
Yes we can load, using stored procedure 1. Need to change pdf to excel /.txt formate.2. Call the procedure in the dummy mapping.
-
What is the difference between Enterprise data warehouse and a data warehouse ??Which all transformation uses the cache directory ?
jryan999
- Sep 1st, 2008
I quite agree with the Enterprise Vs Departmental warehouse. Some background through.The two primary warehouse architectures are proposed by Kimball and Inmon. Inmon used to recommend a sin...
Shashikumar
- Jun 21st, 2007
EDW & DW are one & the same. If scope of data warehouse is enterprise wide it is called Enterprise data warehouse.If the scope of data warehouse is limited to department it is called Data mart.Transformation which uses cache are,Lookup,Joiner,Aggregator,Rank
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
jryan999
- Sep 1st, 2008
The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either...
subashreddy77
- Apr 27th, 2008
Hiwe can connect as we like but it will be generally based on requirements
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
sakthi.jaganathan
- Aug 25th, 2008
The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat file...
Mamta11
- Jul 26th, 2008
Use joiner transformation. If the structure of both the flat files is same you can also use union transformation
-
-
What is a transforamation?
It is a repostitory object that generates,modifies or passes data.
sprajarajan
- Aug 8th, 2008
A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.
bibhu
- Nov 10th, 2006
Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.
-
What are the steps follow in performance tuning ?
J.David Sukeerthi Kumar
- Nov 26th, 2007
Bottle neck means drawbacks or problems
-
What is a junk dimension
vivek1708
- Jul 30th, 2008
Junk dimensions are particularly useful in Snowflake schema and one of the reasons why snowfalke is preferred over the star schema.There are dimensions that are frequently updated. So from the base se...
ravi kumar guturi
- Mar 10th, 2006
A junk dimension is a used for constrain queary purpose based on text and flag values.Some times a few dimensions discarded in a major dimensions , That time we kept in to one place the all discarded dimensions that is called junk dimensions.
-
How do you test mapping and what is associate port?
sreedhark26
- Mar 26th, 2007
HiU can test mapping in mapping Designer by using debugger. In Debugger u can test first instance and next instance. associated port is output port.sreedhar
-
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...
-
Relational connection
Hi friends, I connect the pubs database and i move the data to the target successfully. but i connect the Northwind as the same procedure but the task is failed. I don't know what the fault is this? Anyone answer this question please....
Rocksakthi
- Jul 24th, 2008
Thank you very much for your reply savitha. but i already solve the problem. the problem is informatica cannot accept the space in the table name and field name but in the nothwind database if you imp...
-
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...
-
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
-
When do you use Normal Loading and the Bulk Loading, Tell the difference?
vivekvish
- Jul 24th, 2008
You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.
chandrarekha
- Sep 28th, 2007
Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.
-
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 ...
Informatica Interview Questions
Ans