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

 1787

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

 1760

Can we create Hierarchies in generic datasources?

CTS,

1930

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

 2 4655

tell me few points when u become TL

Infosys,

2027

what make u disappointmnets in u r career

Infosys,

1786

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.

1724

Hi, Lookup() is what kind of join ?

Satyam,

6 10307

what is the difference between cubes and package in cognos

Cognizant,

4532

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

HCL,

1 3617

How we can see table structure?

iGate,

2 5694

What exact we can see in table?

 1 3189

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,

2243

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 5043

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

Tech Mahindra,

3624

Post New ETL Questions

Un-Answered Questions { ETL }

What are the key benefits of ETL Testing?

568

tell me few points when u become TL

2027

What is abap? What are idocs?

518

What are the ETL Testing Operations?

630

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1138




What is initial load and what is full load?

520

Explain about power designer data modeling software?

469

if i have a query as flat file how can we load data to target table

981

flat filevalidation in informatica

1748

Explain about etl data integration software?

488

what are the data modeling tools you have used?(polaris)

1555

What is tracing level and what are the types?

543

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2434

Compare etl & elt?

558

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

1850

For More Un-Answered { ETL } Questions Click Here