I need to comment the stored procedure in the mapping

sreenu

• Nov 19th, 2011

Pass dummy argument and do not connect the output of the stored procedure to actual fields.. you this as pass through transformation if it is a connected one

if it is unconnected t/f then you can simply ignore the output of the field in the expression

Answer Question  Select Best Answer

What is the extension used to store backup of repository?

adilshariff

 Profile Answers by adilshariff Questions by adilshariff

• Jul 1st, 2008

The extension used for Backup Repository is .rep

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer

How to make the connections and How to run in session?

ps77322

 Profile Answers by ps77322 Questions by ps77322

• Nov 5th, 2009

Connection String Creation:First go to the Work flow manager and then select your folder, then go to Connections menu and select Relational and select the type of database from the drop down and ...

Answer Question  Select Best Answer

How do we normalize data which is in .txt comma seperated by using Normalizer transformation and storing the data in a Dimentional table?

ebullientabhinav

 Profile Answers by ebullientabhinav Questions by ebullientabhinav

• Jun 22nd, 2010

Use a file delimiter as ',' comma when importing the file.The comma separated rows will now be now converted into columns which you have to name.Use normalizer now where you want 

Answer Question  Select Best Answer

How can we use mapping parameters?

naidubava

 Profile Answers by naidubava Questions by naidubava

• Sep 17th, 2008

Mapping Parameters: Mapping parameter is a constant value which points to any datatype in the entire mapping. its value will not be changed as earlier said. Mapping variable: Mapping variable is same ...

Answer Question  Select Best Answer

What are active mapplet and passive mapplet?

sarita.harsh

 Profile Answers by sarita.harsh Questions by sarita.harsh

• Mar 12th, 2009

A mapplet can be active or passive depending on the transformations in the mapplet. Active mapplets contain one or more active transformations. Passive mapplets contain only passive transformations. W...

Answer Question  Select Best Answer

What is the difference between sorting data in SQ and SRT transformation?

prashastha

 Profile Answers by prashastha Questions by prashastha

• Nov 12th, 2008

The difference for sorting the data in source qualifier and sorter transformation is that:If your source is relation then you can sort the data in both both transformation.But your source is file then you can only sort those data in Sorter transformation.regards....Prabhu S

Answer Question  Select Best Answer

How to import mapping from one repository to another repository?

priya.kush

 Profile Answers by priya.kush Questions by priya.kush

• Jan 9th, 2009

You can use repository manager for the same.Open the repositories drag and drop the mapping from one repository to other.

Answer Question  Select Best Answer

How can we track history DTA without using Lookup Transformation?

prashastha

 Profile Answers by prashastha Questions by prashastha

• Nov 12th, 2008

Yes it is possible, you can use joiner transformation insted of lookup.In joiner you specify the outer join as source and load the data. regards...Prabhu S

Answer Question  Select Best Answer

How to Upload the MainFrame Source for Informatica ?

DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 19th, 2009

We got mainframe source as VSAM (Virtual Storage Access Method) files, mainframe developers converts these files as Flat files to access data into Informatica for our convenience. The bottom line is "The mainframe data files are in .Dat files(Flat Files)".

Answer Question  Select Best Answer

Why do we need XML Transformation in Informatica?

DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 26th, 2009

1) Whenever we have Q systems, EAI sonorous we need XML transformation. 2) To handle unstructured data/semi structured data (.PDF) we need XML transformation. Because .PDF files had tags, Informati...

Answer Question  Select Best Answer

How to extract data from SAP R/3 system to a DWH?

ntonsalli

 Profile Answers by ntonsalli Questions by ntonsalli

• Feb 12th, 2010

Informatica PowerConnect for SAP R/3 will provide Informatica PowerCenter customers with high-speed data extraction from SAP R/3. Using PowerConnect for SAP R/3, users will be able to access all SAP R...

Answer Question  Select Best Answer

How to create individual sequence numbers for each department wise?

etluser

 Profile Answers by etluser Questions by etluser

• Jan 3rd, 2010

Here are the steps1. Assume that there are four departments and that the source is a source file that contains dept id.2. Create four Sequence Generator transformations.3. Create an exp...

Answer Question  Select Best Answer

Why Union Transformation is active while it passes all the rows through it.

etluser

 Profile Answers by etluser Questions by etluser

• Dec 28th, 2009

By definition, a transformation is treated as active if the number of input rows do not match the number of output rows. Since Union transoformation accepts input rows from multiple pieplines, and com...

Answer Question  Select Best Answer

What are the Connectivity Issues that comes when we connect informatica to Oracle?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Nov 11th, 2009

There can be different reason for the connectivity to fail. It can be either or combination of below:1) Server is down.2) Wait time for the IS of Informatica is too low.3) Network is slow.4) The OS on the server (usually unix) might have not functioned properly.5) Other Technical Snags

Answer Question  Select Best Answer

What are the newly added transformations in informatica powercenter 8.1.1?

deepthinarayan

 Profile Answers by deepthinarayan Questions by deepthinarayan

• Nov 3rd, 2009

1. Java Transformation
2. HTTP Transformation
3. SQL Transformation
4. Unstructured Data Transformation

Answer Question  Select Best Answer

What is a target override table ?

etluser

 Profile Answers by etluser Questions by etluser

• Jul 13th, 2010

Target override is same as Target Update Override. To use this property, set the update override property under the properties tab of the Target instance.Detailed explanation is available by the Power Center help under the topic "Target Update Override".

Answer Question  Select Best Answer

How do you check if a record is a history record or a fresh record?

shiva4mba

 Profile Answers by shiva4mba Questions by shiva4mba

• Oct 13th, 2010

As per my knowledge take a lookup on the target and check with their warehouse keys in the lookup condition

Answer Question  Select Best Answer

What are the server and client components for Informatica Power Center?

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Mar 31st, 2011

Client components are:-1.repository manager administration console, 2.designer,3.mapping designer,4.mapplet designer and 5.transformation developerserver components are:-1.integration service 2.repository service3.web hub service4.sap bw service

Sithara Knk

 Profile Answers by Sithara Knk Questions by Sithara Knk

• Mar 20th, 2011

Repository server administration consoleRepository managerDesignerWorkflow managerWorkflow monitor

Answer Question  Select Best Answer