1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category
ETL Interview Questions
Questions Answers Views Company eMail

What are the new features of informatica 9 version?

2 7883

What is Relational Integrity?

1 3478

working of line item dimension......pls,tell overall flow

1 3615

If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).

 1 11394

How to Check the source record count from traget table.

IBM,

5 12252

how to load the data to fact table?

2155

Can anyone explain me a scenario from banking and finance...more precisely a mapping

IBM,

2065

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

 1 7095

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

HCL,

1927

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

HCL, iGate,

2 5758

What is the main difference between peek stage and copy stage

 2 17641

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

 5 6982

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

 1558

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

L&T,

2098

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

TCS,

1 4257

Post New ETL Questions

Un-Answered Questions { ETL }

What are the modules in Power Mart?

535

Explain etl?

578

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

2572

Explain the difference between etl tool and olap tools?

539

When do we analyze the tables? How do we do it?

528




how many steps are there in etl process?

540

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1736

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2058

what is data modeling?

1902

How to fine tune mappings?

568

What is fact? What are the types of facts?

536

Explain different types of partitioning?

621

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

548

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2165

how do u set partition points in the mapping?

1801

For More Un-Answered { ETL } Questions Click Here