GeekInterview.com
Series: Subject: Topic:

BO Data Integration

Showing Questions 1 - 19 of 19 Questions
Sort by: 
 | 

Duplicate records in target table

Asked By: chintam820 | Asked On: Dec 6th, 2011

What would you do when all the duplicate values are being updated in target table and the job is adding records continuously without any pause ?

Answered by: selva on: Oct 8th, 2013

Target table select Yes to use auto correct loading. Auto correct loading ensures that the same row is not duplicated in a target table

Answered by: Raunak Mali on: Apr 3rd, 2012

1.If you think that duplicate records may be inserted to the target table. Then first while inserting the data into the target table ignore it. And then use "Select Distinct into" method on the targ...

Different delta options other than cdc

Asked By: chintam820 | Asked On: Dec 6th, 2011

In a specific data flow, which has a source table, a transform, and a target table: how would you update the target table with any changes in source table without using a cdc?

Answered by: deepa on: Jun 6th, 2013

We have transforms called table comparison and map operation. by using table table comparison transform we can find the changes from source.

Aggregate data

Asked By: llopez003 | Asked On: Nov 21st, 2012

How do you aggregate data?

Answered by: Deepak Kumar on: Jan 26th, 2013

In Query transform you give a sum()/max()/min() command and group by the rest

What is cascade and drill through? What is the difference between them?

Asked By: sainath | Asked On: May 16th, 2007

Answered by: Sandhya.Kishan on: Apr 12th, 2012

Cascade is a process which takes values from other prompts.It results in a single report and is used based on some condition. Drill through is a process which bis used to navigate from summary to deta...

Error handling

Asked By: darkshadow | Asked On: Sep 30th, 2011

What is an error handling framework?

Answered by: Sandhya.Kishan on: Mar 12th, 2012

Error handling framework indicates serious problems that a reasonable application should not try to catch. Most such errors are abnormal conditions.

Date services real time scenarios

Asked By: chintam820 | Asked On: Dec 6th, 2011

Please write some real time data services scenarios

Table comparison options

Asked By: kumar_bods | Asked On: Dec 5th, 2010

What are the different options in table comparison? What are pre-requisites of sorted input?

Answered by: vuppala on: Oct 13th, 2011

We have 3 options in TC:
Row by row:
Cache comparison:
Input Sort:

How do you import tables from source metadata

Asked By: gssharma_msc | Asked On: Jan 29th, 2007

Answered by: Ramesh on: Sep 14th, 2011

First Datastore has to be defined using related connection stings and you can import metadata for individual tables using under datastore window using the following ways.

Browsing
Name
Searching

Answered by: pavani_yerra on: Jun 18th, 2010

Hi,Right click on datastores (Where ur source tables are exist) and click on open. It'll list out all the metadata related to that datastore. Select the particular table which you want to import r...

Is there any way to perform cartesian product between 2 flat files?

Asked By: sri.dwh85 | Asked On: May 25th, 2011

I have 2 flat files and I want to perform cartesian product. Any one know how to do it?

Answered by: Ramesh Kumar Samy on: Jun 4th, 2011

use exp transformation and add dummy port in the both flat files like ( rnum=1) , then use joiner transformation ,make normal join . u will get Cartesian prod

Query transform and SQL transform

Asked By: etl_bhargavi | Asked On: Feb 15th, 2008

What is the difference between query transform and SQL transform in bodi?

Answered by: amuh1026 on: May 23rd, 2011

Query transform is something you build using the BODI, and it generates the optimised SQL, where SQL transform allows you to enter the SQL query directly.

Answered by: gssharma_msc on: Feb 27th, 2008

SQL Transform - Here you can wirte your customized SQL queries.Query Transform - This is one of the best tranformation in BODI, where it gives u different functionalities like Extracting data, sorting...

Power exchange dx/dt

Asked By: catchchinna | Asked On: Apr 11th, 2011

Hi,can any one please explain in detail about the power exchange dt/dx?Thanks in advance.

Lookup and change capture

Asked By: greek143 | Asked On: Aug 11th, 2010

What is the difference between lookup & change capture stages?Can we change capture stage instead of lookup?

What is di hierarchy, what are the resuable objects

Asked By: gssharma_msc | Asked On: Jan 29th, 2007

Answered by: pavani_yerra on: Jun 18th, 2010

Hi,In DI the hierarchy as follows.Project->JOB->WorkFlow->DataFlowResuable objects are nothing but the objects which we can use more than once in our DI. Once u modify the object it'll ef...

Answered by: Aparna on: Mar 19th, 2007

Data Integrator hierarchy is as follows                           ...

SQL transform customized SQL queries

Asked By: eswar4u | Asked On: Mar 25th, 2010

Explain what are customized SQL queries?

Answered by: pavani_yerra on: Jun 18th, 2010

Hi,

Customized queiries means the complex queries which we cant execute the functionality by some other built-in transforms.

Bulk loading in bodi

Asked By: shilpa_bodi | Asked On: Jun 4th, 2010

Why is bulk loading faster than normal loading in bodi?

Answered by: pavani_yerra on: Jun 18th, 2010

Hi,API bulkloading is faster than file method because in convetional file method it has to write some log files and then invoke a SQl *loader. in API method it will directly connects to the sql engine...

SCD implementation in di

Asked By: shilpa_bodi | Asked On: Jun 4th, 2010

What transforms do you use to implement SCD type ii in di ??

Answered by: pavani_yerra on: Jun 18th, 2010

Hi,

We can implement SCD type 2 using table comparision, History preserving,key generation transforms.
src->table comparision->history preserving->key generation -> target

How do you implement full outer join

Asked By: etl_bhargavi | Asked On: Feb 15th, 2008

How we will implement full outer join in bodi?Explain with some examples?

Answered by: gssharma_msc on: Feb 28th, 2008

You can acheive this by two methods1. Use SQl transformation and write your own query2. First apply right outer join and then left outer join and merge it.Ex:- 1. select e.*, d.dname, d.deptno dno, d....

What is the difference between lookup(0 and lookup_ext()..

Asked By: etl_bhargavi | Asked On: Feb 15th, 2008

What is the difference between lookup(0 and lookup_ext() functions in bodi?

Answered by: gssharma_msc on: Feb 27th, 2008

lookup() - It will compare only single coloumn and return only single port
Where as
lookup_ext() - will compare multiple columns and return multiple rows

Parallel processing projects and grid processing projects

Asked By: ramasamba | Asked On: Feb 8th, 2008

What is the difference between parallel processing projects and grid processing projects

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.