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

How can we know the session status without workflow monitor?

etluser

 Profile Answers by etluser Questions by etluser

• Jul 12th, 2010

Check s_m_*.log files under SessLogs folder and wkf_*.log files under WorkflowLogs folder on the server.

Answer Question  Select Best Answer

Why row type should be used only with Normal/Master Outer Join?

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

In normal join only matching rows from both the master and detail table will be joined and in the case of master outer join all rows from the detail table will be kept and only matching rows from the ...

Answer Question  Select Best Answer

How can we update the target table without using update strategy?

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

There is a update Override option in the Target properties, you can write a update override query similar to SQL override in lookup's for updateing Targets. This option is enabled only at the mapping level i.e; in the designer you have to write your update override query in designer itself.

Answer Question  Select Best Answer

You need to prepare common documentation of session, source and target. How will you make it?

sraghav20

 Profile Answers by sraghav20 Questions by sraghav20

• Sep 16th, 2010

You should put in appropriate comments/documentation at the metadata extension for each transformation object / mapping / session etc..  Basically for each object.further, you can use metatdata reporter equivalent to generate appropriate document for the mapping/folder etc...

Answer Question  Select Best Answer

You transfer 100000 rows to target but some records get discarded, How will you trace them and where its get loaded?

sakshi.chopra

 Profile Answers by sakshi.chopra Questions by sakshi.chopra

• Sep 26th, 2010

The discarded records can be traced from Reject file. Also optionally you can choose Relational database error logging and the discarded records can be traced from error log tables generated by Integr...

Answer Question  Select Best Answer

Why single level and nested expressions is not supported in same Aggregation transformation?

gopalzoro

 Profile Answers by gopalzoro Questions by gopalzoro

• Oct 20th, 2010

If an Aggregator transformation contains a single-level function in any output port, you cannot use a nested function in any other port in that transformation. When you include single-level and nested...

Answer Question  Select Best Answer

How to call SQL stored procedures in Informatica?

kotireddy

• Apr 28th, 2012

Using Store Procedure t/r call it

Answer Question  Select Best Answer

How will you find the errors in mapping or session by sessionlog. What are the alternative options to know the errors?

reshhhhhh

 Profile Answers by reshhhhhh Questions by reshhhhhh

• Sep 23rd, 2010

The sessionlog will give the details of the complete working of the session. With this you can find out where the session failed. In addition session log will also give an error number to provide the type of error that has occurred.Other option to find the error is to debug the session.

Answer Question  Select Best Answer

How to remove duplicate values in mapping?

abhiora24

 Profile Answers by abhiora24 Questions by abhiora24

• Oct 26th, 2010

If Source is Flat File then useSORTER transformation/Aggregator transformationIf Source is RDBMS then useAggregator transformation

Answer Question  Select Best Answer