Sign Up Login


  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

 1940

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

 1957

Can we create Hierarchies in generic datasources?

CTS,

2091

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

 2 5054

tell me few points when u become TL

Infosys,

2196

what make u disappointmnets in u r career

Infosys,

1954

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.

1934

Hi, Lookup() is what kind of join ?

Satyam,

6 10937

what is the difference between cubes and package in cognos

Cognizant,

4713

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

HCL,

1 3873

How we can see table structure?

iGate,

2 6058

What exact we can see in table?

 1 3457

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,

2408

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 5463

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

Tech Mahindra,

3840

Post New ETL Questions

Un-Answered Questions { ETL }

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

1148

how do use session mapping parameters ?(in which transformation)

1624

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1553

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?

2014

What is cube grouping?

739




Explain about enterprise scalability and roi of data integration suite?

644

How many steps etl contains?

691

where are the log files generally stored.Can you change the path of the file.what can the path be?

2132

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?

703

How etl testing is different from database testing?

711

what happens if the info.server doesn't find the session parameter in the parameter file?

1706

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

711

What do you understand by the term ‘transformation’?

711

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1734

how to load the data to fact table?

2367

For More Un-Answered { ETL } Questions Click Here