chinnu

• Feb 21st, 2007

Through Source Qualifier

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Datawarehouse means it is the repository of integrated information in this OLTP part is there and OLAP part is also there E-R model it is the poor model and it is difficult to understand  and it ...

Answer Question  Select Best Answer

sravan

• Nov 4th, 2006

Target oad pan specifies the order in which the data being extracted from the source qualifier.

ram gopal

• Oct 24th, 2006

In a mapping if there are more than one target table,then we need to give in which order the target tables should be loadedexample: suppose in our mapping there are 2 target table 1. customer2. Audit ...

Answer Question  Select Best Answer

Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up some Dim ID,in this way,I must lookup twice.I think its not a good way.It's there another better?

kishore

• Nov 1st, 2006

Use session option truncate table.if you use this option whenever you start the session it will delete the target table records and then load the new records.

sats

• Nov 1st, 2006

well...u can use the option Truncate target in session(target properties)or use a truncate statement in pre-sql statement.either of the two should work fine..

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Connected stored procedure will execute when each row passed through the mapping then it will execute, Unconnected stored procedure will execute when it is called by the another transformation, and connected stored procedure is the part of a data flow in a pipe line but unconnected is not.

Answer Question  Select Best Answer

I have a flat file as my source containing 100 records and i have two load this flat file data into two different targets .these two targets reside in two different sachems actually?

shaik

• Dec 20th, 2006

Yes u can load into different targets with different schema.First check source columns which matching to target table column and then load.

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

ERP stands for Enterprise resource Planning for business developments and maintenance.Each and every database to store the organisation data is known as ERP.

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 9th, 2006

Its one kind of report. generally we will use this one in cognos

Answer Question  Select Best Answer

satya

• Nov 16th, 2006

 It is the ability to dynamically re-write SQL to the level of granularity neededto answer a business question

Answer Question  Select Best Answer

When we are extracting the data from excel sheet. at session level how can we set the database connection for excel sheet?

PooraniAshokkumar

• Nov 29th, 2006

hithis extraction of data can be done in another format alsowhat u can dou can copy the data from excel sheet to a notepad file then u can load the data in the source using import from flatfilethen in...

Answer Question  Select Best Answer

PavaniKatta

 Profile Answers by PavaniKatta Questions by PavaniKatta

• Dec 11th, 2006

Source qualifier transformation is used to extract the data from one or more tables from RDBMS of the same instance or from a single flat file system.Application Source Qualifier transformation is used to extract the data from Application sources like ERP.

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

You can identify source bottlenecks by executing the read query directly against the source database. Copy the read query directly from the session log. Execute the query against the source database w...

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

Custom transformation To extend the powercenter functionality by using outside developed procedures. You can create Custom transformations with multiple input and output groupsFor any queries: sriram_kumar @ one...

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

PIPELINE SPECIFIES THE FLOW OF DATA FROM SOURCE TO TARGET .PIPELINE PARTISON MEANS PARTISON THE DATA BASED ON SOME KEY VALUES AND LOAD THE DATA TO TARGET UNDER CONCURRENT MODE. WHICH INPROVES THE ...

Answer Question  Select Best Answer

tryyogi

• Jan 15th, 2007

The error codes are in Hex .You have to convert it in Decimal to have the actual error code in Unix.Googling around you would find the error code-desc pairs on some pages. This error particularly is "Not a super user" ,as far as my memory doesn't fail me.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

2004

Answer Question  Select Best Answer

Lingesh kumar

• Jan 31st, 2007

Hi, Generally any mapping is run from UNIX i..e UNIX shell script calls work flow.work flow intern calls mapping. Suppose i am generating a flat file in unix from informatica mapping,if i nee...

Answer Question  Select Best Answer

madhavkash

• Jun 22nd, 2007

Register the flat file as source and create a mapping with file as source.After SQ Txf, create a Filter Txf and make it false to write to a dummy target.Create a workflow and in that session variable SrcSuccessRows > 0 True means you have data False means no data

Answer Question  Select Best Answer

anu

• Jan 25th, 2007

Are you lookuping flat file or database table? Generaly, sorted joiner is more effective on flat files than lookup, because sorted joiner uses merge join and cashes less rows. Lookup cashes always who...

Answer Question  Select Best Answer