Can we load data from a pdf to a table using informatica.

adilshariff

 Profile Answers by adilshariff Questions by 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

 Profile Answers by balajirajd Questions by 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.

Answer Question  Select Best Answer

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....

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 29th, 2008

Use :LKP.transformation_name(column1,col2,...)

Rocksakthi

 Profile Answers by Rocksakthi Questions by 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...

Answer Question  Select Best Answer

Why the input pipe lines to the joiner should not contain an update strategy transformation?

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Joiner will join two groups of data either homogeneous or heterogeneous, and this join will happen horizontally. One scenario why use of update strategy is prohibited upstream of joiner t/f as below ...

Etl Developer

 Profile Answers by Etl Developer Questions by Etl Developer

• May 28th, 2010

This scenario is illogical, First we need to understand the functionality of each repository object.Update strategy: This transofrmation is used to maintain the transaction data based on differen...

Answer Question  Select Best Answer

If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?

Read Best Answer

Editorial / Best Answer

etluser  

 Profile Answers by etluser Questions by etluser

• Member Since Dec-2009 | Dec 31st, 2009

---

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

There is a concept of Indirect filelist for processing multiple files with similar structure.

Rajath

• Feb 20th, 2012

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

Improve Answer

Explain the suppress comment in lookup override?

khurana29_amit

 Profile Answers by khurana29_amit Questions by khurana29_amit

• May 16th, 2010

If I write the overide query for lookup without order by and  "--" at the end then will it take order by from default query?

madhu.tella

 Profile Answers by madhu.tella Questions by madhu.tella

• Mar 25th, 2010

Lookup override is nothing but just simply overriding the default sql which is generated by lookup by the runtime, default SQL contains SELECT and ORDER BY caluse and the order by clause ord...

Answer Question  Select Best Answer

Why should not we use sorted input option when using Incremental Aggregation?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

Because of the performance tunning, because here the duplication of the data is sorted in the bginining of the aggregation itself so index cache and data cache ?is reduced so the performance is good.

ahammed

 Profile Answers by ahammed Questions by ahammed

• Jul 21st, 2010

When you are selecting sorted input the data will be sorted and at the same time last record key value will be stored in repository. After that days or months passing on some new records will be ...

Answer Question  Select Best Answer

What kind of join (Inner,Outer,FULL) does a lookup generate while being used in a mapping in order to search for a particular field value?

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 5th, 2010

When used in mapping, is generates a inner join by default. However when it returns the value to the system, it does returns a NULL for unmatched records. So we can say that it is left outer join. So we must make sure in which context the question is asked.

Saravanabalaji

 Profile Answers by Saravanabalaji Questions by Saravanabalaji

• Aug 20th, 2010

The Look Up transformation does a Left Outer Join

Answer Question  Select Best Answer

One fact table is surrounded by only one dimension table. Is it star schema or not? Give any real time example?

Rajan Raorane

 Profile Answers by Rajan Raorane Questions by Rajan Raorane

• Oct 21st, 2010

Fact table surronded by Dimension table in which Dimension table must have primary key and fact table must include foriegn key

srikanthsanga

 Profile Answers by srikanthsanga Questions by srikanthsanga

• Sep 23rd, 2010

Star schema doesn't mean that it has to be surrounded with dimension tables it depends on whether the dimension table have any more relation table to it if it has then it becomes a snow flake schema otherwise its considered as star schema

Answer Question  Select Best Answer

Supose we have 4 column based on same condition can we use unconnected lookup in that case?

Yoganand

• Aug 9th, 2011

Hi,

We can pull any number of columns in unconnected lookup nut with the help of Lookup override. We can concatenate many columns and then use an expression to deconcat those values.


Thanks,
Yoganand

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala Questions by Nagaraju Puppala

• Feb 9th, 2011

Yes it's Possible.Suppose the look up table contains the group values, and the primary is a combination of EMP_NO, DEPT_NO.to get the EMP_NAME from the unconnected lookup, we should pass the EMP_I...

Answer Question  Select Best Answer

How to load source into target 2 times?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

For this Question I can provide four answers
1. By using union Transformation
2. Connect target two times to two source
3. By using Target load plan
4. By using Java transformation

Note: All of the methods works only when the target having no Primary key or Unique Key.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

hi, we cannot use router transformation because router transformation is condition dependent and data is stored into multiple target. For using push-down optimization(Source-Qualifier) data is stored...

Answer Question  Select Best Answer

What are limitations and delimitations of Joiner Transformation?

jyothi_rayala

 Profile Answers by jyothi_rayala Questions by jyothi_rayala

• Feb 28th, 2011

Joiner transformation cannot be used in the below scenarios ? Both pipelines begins with the same original data source. ? Both input pipelines originates from the same source qualifier. ? Bo...

Ishita_dts

 Profile Answers by Ishita_dts Questions by Ishita_dts

• Feb 26th, 2011

No active transformation should be there upstream the joiner.

Answer Question  Select Best Answer

How to create mapping that half records will go to one target and half to another target?

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Use the sql override in source qualifier as select col1, col2, (select count(*) from table) from table;

In the mapping flag the rows into groups in router t/f as count(*) port count(*)/2

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

Create two source qualifier write a query in SQL override select * from emp where rownum in(select count(*)/2 from emp)another
SQL override write a queryselect * from empminusselect * from emp where rownum in(select count(*)/2 from emp)
To connect target

Answer Question  Select Best Answer

I have two target tables,so i want to make Union of both the target,so please let me know about this

santanu

• May 11th, 2012

Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table

Sreedhar Lokaray

• Nov 3rd, 2011

I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to loa...

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Dec 20th, 2011

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target. Pre-load of...

Anubhav Raikar

• Nov 15th, 2011

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad th...

Answer Question  Select Best Answer

Suppose in my mapping 3 pipelines are there from source to target and i want to run the middle pipeline only.

Suhel Shaikh

• Nov 24th, 2011

Example; If we have two pipelines in a single mapping then whichever pipeline you do want to run just add 1=2 in the SQ override as a last statement.And create two sessions for the same mapping and add this statement to the SQ of one source which you don't want to run.It will run the other one.

SEHAJ SHANGARI

• Aug 18th, 2011

In designer.
Select mapping tab
There is a property target load plan
Select the source qualifier and the target which u want to run the first n place it in first position. Followed by other pipelines

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

kumar

• Oct 21st, 2011

First we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

Answer Question  Select Best Answer

ash.singh1790

 Profile Answers by ash.singh1790 Questions by ash.singh1790

• Jul 13th, 2014

1. Session Properties
2. Under General Options ---> Check "Enable Test Load" ---> Insert 10 in "Number of rows to test"

Mayur

• Jun 19th, 2014

In Session property we have one option that is Performance data check, if you click that option you it will give transformation wise result.

Answer Question  Select Best Answer

Can you update target as a flat file, without using updated strategy trasformation

Khota

• Jun 5th, 2013

You cannot update a flat file

veena

• Mar 8th, 2013

Yes we can update target without using Update Strategy Transformation in
session->mapping->target->treat source rows as
Update
Update as Update
Update else insert
Update as Insert

Answer Question  Select Best Answer

How do you validate the no of rows received in source with footer(count) and if both count matches then only it should load to target?

vijay

• Jan 6th, 2014

Design a mapping with 2 flow.1 to load the data into target with all necessary columns.2nd target will have only count information and set a target load plan as said above.In the session level. Set th...

saurav

• Apr 4th, 2013

You can utilize the MD5 hash functionality within the mapping

Answer Question  Select Best Answer

Vikas Nandal

• Apr 21st, 2013

Create a Dummy Port in both tables and assign same value e.g. 1 to both ports in expression transformation before joiner.
Now in join condition use this dummy port to join both tables.

anshuman trivedi

• Mar 3rd, 2013

You join these table using null key.

Pass {} to the key,I am sure it will work.

Regards,
Anshuman

Answer Question  Select Best Answer