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

what do u do when DB time takes more?in sap bi

 1781

what is the use of structures?how many nodes can u create in a structure?

 1754

Can we create Hierarchies in generic datasources?

CTS,

1926

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

 2 4642

tell me few points when u become TL

Infosys,

2024

what make u disappointmnets in u r career

Infosys,

1782

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1720

Hi, Lookup() is what kind of join ?

Satyam,

6 10291

what is the difference between cubes and package in cognos

Cognizant,

4524

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

HCL,

1 3605

How we can see table structure?

iGate,

2 5687

What exact we can see in table?

 1 3180

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

Thomson,

2240

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

Cognizant, IBM,

2 5028

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

Tech Mahindra,

3615

Post New ETL Questions

Un-Answered Questions { ETL }

Compare ETL & Manual development?

554

What do you understand by active and passive transformations?

550

Explain about hash partitioning?

541

Identifying the bottlenecks in various components of Informatica and resolving them.

2173

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1629




When do we go for the tools in the market?

550

What is etl process. How many steps etl contains explain with example?

515

what are the cubes developed in a sap bw project and what is the requirement for developing it?

1715

Can u access a repository created in previous version of Informatica?

1466

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

1731

What is abap? What are idocs?

516

What are the various tools used in etl?

546

List few etl bugs?

526

dimension object created in oracle can be imported in designer?how?

2454

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

526

For More Un-Answered { ETL } Questions Click Here