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

Dichen Kumar Mishra

• Feb 21st, 2007

1st u have to check the source file name,target file name that u set in Session edit being present in the unix server or not.If not present by applying the CP command:-make copy from one file to other.Regards,Dichen Kumar Mishra

Answer Question  Select Best Answer

What is the use of BUSINESS COMPONENT object ? When do we use them?

SRIRAM N

• May 9th, 2007

Business component object is used to categorise the objects.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

Hi:Trigger can not be called from Stored procedure. Trigger will execute implicitly when u are performing DML operation on the table or view(instead of views).U can get the difference between trigger and sp anywhere in the doc.Hanu.

Answer Question  Select Best Answer

SRIRAM N

• May 17th, 2007

You can compare two mappings 1) with in one folder 2) two mappings in two differnt foldersMapping Designer --> Open folders--> MAPPING tab --> Compare then select two mappings to compare.Thats it !? Thanks it is working.

Answer Question  Select Best Answer

satoru

 Profile Answers by satoru Questions by satoru

• Jul 7th, 2010

Cube is a multidimensional representation of data. It is used for analysis purpose. A cube gives multiple views of data.

Answer Question  Select Best Answer

Navin

• Jun 2nd, 2007

With 32-bit the max memory?you can have for a session is 2^32With 64-bit?the max memory you can have 2^64 - more memory means?faster execution of sessionNavin

Answer Question  Select Best Answer

ramgan_tryst

 Profile Answers by ramgan_tryst Questions by ramgan_tryst

• May 15th, 2007

Check-In and Check-Out refers to Versioning your Mapping. It is like maintaining the changes you have made. It is like using VSS or CVS. When you right-click you mapping, you have a option called Versioning if you have got that facility enabled.

Answer Question  Select Best Answer

babu

• Jul 11th, 2007

In?above the condition satisfies is:1 satisfies A , A or B2?satisfies?B,?A or B1, 2?does not satisfies it goes to DEFAULTThere is no use of?A and B.

Answer Question  Select Best Answer

mohammed haneef

• Jun 28th, 2007

Hi,Joiner Cache will use in Joiner t/r  to improve the performance. While using joiner cache informatica server first read the data from master source and built data index & data cache in the...

Answer Question  Select Best Answer