butair

 Profile Answers by butair Questions by butair

• Aug 3rd, 2009

Client:-* GUI/Presentation logic* Query specification* Data Analysis* Report formatting* Data accessApplication/Data Mart Server:-* Summarizing* Filtering* Meta Data* Multidimensional view* Data accessDW Server:-* Data logic* Data services* Meta data* File services

shayona

 Profile Answers by shayona Questions by shayona

• Jun 1st, 2009

Three tier data warehouse contains three layer. 1st layer does all the data extraction and 2nd layer does transformation and in 3rd layer there is loading of clear data.

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

Salman Baig

• Aug 17th, 2014

Partitioning is a technique which partitions data across several disks and exploits bandwidth of disks by storing and retrieving in parallel.It reduces the time required to perform the access of data ...

DWH01

 Profile Answers by DWH01 Questions by DWH01

• Jul 9th, 2008

Oracle provides partitioning of Tables, Indexes and IOTs to split their contents into different partitions.  Each partition could be on a separate physical drive.  This provides faster perfo...

Answer Question  Select Best Answer

This is the recent question faced in ibm.

sri_test

 Profile Answers by sri_test Questions by sri_test

• Dec 16th, 2008

It is not possible to combine two tables with different sources,so first convert the department table normal oracle targetMapping 1:1: For cobol dept source use normalizer to convert to oracle target2...

Mamta11

 Profile Answers by Mamta11 Questions by Mamta11

• Oct 14th, 2008

This can be done in informatica mappinsg by using the Aggrgator transformation.Select all the ports from source qualifier joining on departmetn into aggregator .Group by departmetn no and select max(salary)

Answer Question  Select Best Answer

pvsunil123

 Profile Answers by pvsunil123 Questions by pvsunil123

• Apr 15th, 2009

I assume ETL coding means using ETL tools like Informatica.If the data is coming from completely different source systems as flat files, cobol files, RDBMS, XML, etc., it is better to use some intelli...

sri_test

 Profile Answers by sri_test Questions by sri_test

• Dec 16th, 2008

Usually Warehouse is preferred in banking,insurance,health care domains. In these environments especially in banks output is provided by business person in excel,notepad,word,Access format. Suppose if...

Answer Question  Select Best Answer

I have a ebcdic file, I wanted to select only first 2 columns values in the output in the m_dump command
Output of m_dump values are like below:
[record
id "100"
type_code "20"
frstname "abcd"
lastname "efgh"
new_line "
"]
any help is greatly appreciated

Ashiq Aashu

• Jun 4th, 2018

You can use m_dum < adc.dml > < source file name > -select < expression > hope it will work if you have write a mail.

salma

• Mar 5th, 2018

M_dump -start 1 -end 2 |egrep Record|id|type_code

Answer Question  Select Best Answer

What are the T/Rs which create cache files?

sowjanya

• Oct 21st, 2014

Sorter,lookup,joiner,rank,aggregator

deepthi

• Aug 20th, 2011

Aggregator
joiner
lookup
rank
sorter

Answer Question  Select Best Answer

Answer posted by Staline on 2005-05-27 00:42:44: You can use a Command task to call the shell scripts, in the following ways:  1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands.  2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information...

Hanuma

• Jul 24th, 2011

You can use a Command task to call the shell scripts, in the following ways: 1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands. 2. Pr...

praveenathota

 Profile Answers by praveenathota Questions by praveenathota

• Nov 13th, 2006

Hi,There are two ways to do this,they are as follows:1)we can use a command task anywhere  in the workflow or worklet to run the shell commands.2)In the session task,we can call reusable command ...

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

A Materialized View is just that.  A view which has been materialized to become a "table". The big difference between a View and a Materialized View, is a View executes a query on-t...

naresh sharma

• Nov 2nd, 2006

Materliazed view log is for audit trail purpose on table. This concept was introcuded in Oracle 9. Thsi will help to trace the record based on it's dml operation.

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

You need Lookup Transformations because Dimension Tables are linked to Fact tables by Surrogate Keys.   The Surrogate Key is automatically generated within the warehouse, and the ONLY way to f...

Naresh

• Oct 5th, 2006

  Look Up Transformation is generally used when a fixed data is not present in the mappings we use but is required in the ware house or look up is more importantly used to compare the values...ex...

Answer Question  Select Best Answer

Shiv

• Oct 11th, 2012

Hi, If you even do dynamic lookup you should make use of update strategy to mark the records either to insert or update in the target using look-up cache (look-up will be cached on target). your re...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• May 12th, 2008

Update strategy transformation determines whether to insert, update, delete or reject a record for the target.  We can bypass update strategy transformation by creating a router to divide ro...

Answer Question  Select Best Answer

what are the roles and responsibilities of an ETL developer/designer/team lead?

Ragupathi

• Apr 19th, 2015

ETL Developer roles and responsibilities are 1.Understand the etl specifications and build the etl applications like Mappings on daily basis 2.Need to fetch the daily data from various sources like...

SQLGal

 Profile Answers by SQLGal Questions by SQLGal

• Jun 7th, 2009

The ETL developer's responsibility is to ensure that the goals of the business with regards to data management are met.  The developer should be able to design and implement a plan for a...

Answer Question  Select Best Answer

Why is it necessary to clean data before loading it into the Warehouse

Prashant Khare

• Oct 3rd, 2012

Data Cleansing is a process of detecting and correcting the corrupt and inaccurate data from table or database.
There are following steps used:-
1) Data auditing
2) Workflow Specification
3) Workflow Execution
4) Post-processing and controlling

32kris

 Profile Answers by 32kris Questions by 32kris

• Aug 11th, 2010

Cleaning is required as it helps in maintaining the uniforminty of the target data.

Answer Question  Select Best Answer

Uttam22

 Profile Answers by Uttam22 Questions by Uttam22

• Feb 21st, 2014

A ETL Tester primarily test source data extraction, business transformation logic and target table loading . There are so many tasks involved for doing the same , which are given below - 1. Stage tab...

radhakrishna

• Nov 4th, 2013

ETL tester responsibilities are: writing sql queries for various scenarios like count test, primary key test, duplicate test, attribute test, default check, technical data quality, business data qua...

Answer Question  Select Best Answer

How to select the Even and Odd records in SQL server and in Oracle without using ROWNUM,ROWID

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

"oracle8 TO SELCT EVEN RECORDS IN ORACLE : ----------------------------------------------- SELECT CUSTOMERID FROM (SELECT CUSTIMERID, CASE WHEN MOD(CUSTOMERID,2)=0 THEN EVE...

MUKUL MALIK

• Aug 22nd, 2016

SELECT customerid,case when customerID %2=0 then even
when customerID %2 < > 0 then odd end as result from customers

Answer Question  Select Best Answer

How to find number of duplicate records?

Swathi

• Sep 26th, 2017

We can find the duplicates using SQL Query.

Code
 

Harsha

• Jun 10th, 2016

Code
 

Answer Question  Select Best Answer

Source have phone number with 8 digit and target has 10 digit. How to test target phone number has 10 digit start from +91?

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

First Thing: If phone_num is type numeric, + is not allowed. Second Thing: If phone_num is varchar, and the length of the phone_num is 8 in source, if you want +91 to be appended in the beginning the ...

Naushad

• May 17th, 2016

Code
 

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

dtennes

 Profile Answers by dtennes Questions by dtennes

• Jun 9th, 2009

You cannot use Informatica to extract data from SAP via ABAP.  Only the SAP/Business Objects Data Integrator product can do this.Informatica uses a data dictionary interface, with clear SQL instr...

rasmi

 Profile Answers by rasmi Questions by rasmi

• Apr 3rd, 2008

Hi,We can extract SAP data by using informatica with the powerConnect option.We need to install and configure the powerConnect tool . Import the Source in to the Source Analyzer. Here PowerConnect is ...

Answer Question  Select Best Answer

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 12th, 2008

Need to have reconciliation strategy to very input and output data with reject counts

Anil

• Nov 9th, 2006

Hi, u can check out the session logfiles for the total number of records added number of records udated and number of rejected records and errors related to that so this is the answer the interviewer is expecting from usk

Answer Question  Select Best Answer