siraj.khan

• Aug 3rd, 2007

With the help of a source Qualifier and Lookup we can overide SQL Query.

nashim

 Profile Answers by nashim Questions by nashim

• Jan 17th, 2007

We can override a sql query in the sql override property of a look up and update trasformations.

Answer Question  Select Best Answer

The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a legacy system like AS400 application or Mainframe application. List out all such methods of data capture. The ETL can be Informatica, data stage or custom etl code.

Sriram

• Jul 13th, 2007

Assuming this is a Type1 Dimension or a FACT table on the DWH - Create Date and Update Date will be 2 system dates captured and stored on the Datawarehouse. First time Creation_Dt = Update_Dt.&nb...

Answer Question  Select Best Answer

Abhijit Jagtap

• Jul 12th, 2007

You can Oracle PL/SQL stored procedure from Informatica using the STORED PROCEDURE Transformation. But it needs ODBC connection. You can pass the parameters to the stored procedure through a mapping. There are two ways :-1. Stand alone2. in the mapping flow.

rajesh

• Jul 14th, 2005

We can use External Procedure Transformation to use external procedures. Both COM and Informatica Procedures are supported using External procedure Transformation

Answer Question  Select Best Answer

noverino

 Profile Answers by noverino Questions by noverino

• Feb 23rd, 2007

Push strategies:   - ETL waiting notification for data would be processed. If the notification contain     no data to be processed, ETL must retrieve itself to the source.   -...

prav2000

 Profile Answers by prav2000 Questions by prav2000

• Dec 21st, 2006

Push and Pull strategies determine how data comes from source system to ETL server.Push : In this case the Source system pushes data i.e.(sends data) to the ETL server.Pull : In this case the ETL server pulls data i.e.(gets data) from the source system.

Answer Question  Select Best Answer

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 22nd, 2007

Update strategy, Supposed you have a router you are router has 3 groups, 1 group is for update, 1 group is for delete, 1 group is for insert to target table.  You can use the update strategy for ...

Rangini vignesh

• Aug 29th, 2006

Ans:We can use Update strategy transformation in two ways .1.Mapping level.2.session level.Importence of Update strategy transformation in both cases as follows.In real time if we want to update the e...

Answer Question  Select Best Answer

prav2000

 Profile Answers by prav2000 Questions by prav2000

• Dec 21st, 2006

Majority of the times the DataWareHouse core tables are in a 3NF form and this is where your entity relationship comes into picture.Further you can have fact and dimension tables which are populated using the core tables. The fact and dimension tables follow the star schema or snow flake schema.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

Entity is nothing but an object usually it is table containing the attributes(columns)ETL is a tool not a modeling .. it's useful for transfrering the data from the sources (hetogeniuos) to the targ...

Answer Question  Select Best Answer

PFD333

• Nov 6th, 2006

Unconected lookups are used in cases where it is not necessary for all the rows to pass through it i.e. for each i/p row query need not be done.

venkata veluguri

• Oct 15th, 2006

We can use more than one return port using Un-connected Lookup (Lookup override).  As per my knowledger Un-connected Lookup is useful when we need to call the same lookup multiple times in the mapping.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 17th, 2006

If u r taking connected we return the more than one port, in this we can use the static and dynamic cache and it will support the user defined values.If u r taking unconnected we return the only one port it will support only oracle with this we can use dynamic cache not static.

rajkumar

• Oct 10th, 2006

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

Answer Question  Select Best Answer

sathya

• Oct 10th, 2006

1)ETL Tools IBM Websphere Information Integration(Ascential Datastage) Ab Initio Informatica2)OLAP ToolsBusiness ObjectsCognosHyperionMicrosoft Analysis ServicesMicrostrategy3)Reporting ToolsBusiness Objects(Crystal Reports)CognosActuate

rockky

• Aug 7th, 2006

There is also Group 1's Sagent. Excellent ETL tool along with some aspects of BI as well.

Answer Question  Select Best Answer

Monark

• Jul 28th, 2006

IDP is the portal for display of reports, stored process, information maps and a whole bunch of thing ideally required for a dashboard reporting.IMS, is the gui to help u convert ur technical data and map it to business data (change names, add filters, add new columns etc)

Ram

• Jul 18th, 2006

In SAS what is Information Delivery Portal and Information Map StudioRegards,Ram

Answer Question  Select Best Answer

sree,prabhakar

• Jul 14th, 2006

Additve: A masure can participate arithmatic calulatons using all or any demensions.Ex: Sales profitSemi additive: A masure can participate arithmatic calulatons using some demensions.Ex: Sales a...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

There are pros and cons of both tool based ETL and hand-coded ETL. Tool based ETL provides maintainability, ease of development and graphical view of the flow. It also reduces the learning curve on th...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

paddy

• Dec 6th, 2005

Sq is a connected transform. cant do it.

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 14th, 2006

Yes it supports 6.1.3 on words

ravi kumar guturi

• Mar 10th, 2006

yes, But it supports only in 7.1

Answer Question  Select Best Answer

Ram

• Feb 28th, 2006

  Hi,   When u load data intitially in to datawarehouse it will be Full Load.   If u r loading data everyday in to datawarehouse it will be incremental load   Thanks,   Ram 

Sriharsha Hanumanth

• Aug 23rd, 2005

Full Load: completely erasing the contents of one or more tables and reloading with fresh data.  Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Informatica Metadata Exchange (MX) provides a set of relational views that allow easy SQL access to the Informatica metadata repository. The Repository Manager generates these views when you create or...

dhpuneet

 Profile Answers by dhpuneet Questions by dhpuneet

• Jan 18th, 2006

Hi Ravi ,If possible please elaborate on Informatica SuperGlue.RegardsPunu

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Normally ETL Tool stands for Extraction Transformation Loader This helps you to extract the data from different ODS/Database, If you have a requirement like this you need to get the ETL tools, else you no need any ETLCheers,Sithu

Praveen

• Aug 14th, 2005

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL c...

Answer Question  Select Best Answer

dvs

• Nov 5th, 2005

draw the inference if slowly changing dimension and based on the Type 1/2 or3  tables defined.

Andy

• Aug 23rd, 2005

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Ord...

Answer Question  Select Best Answer

Sriharsha Hanumanth

• Aug 23rd, 2005

1. PowerMart Designer 2. Server 3. Server Manager 4. Repository 5. Repository Manager

Answer Question  Select Best Answer

sampath

• Jul 24th, 2005

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder wher...

Answer Question  Select Best Answer