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

JS

• Apr 21st, 2016

Row by Row: When you have large table with less columns data then it is fine.

Cache comparison: When you have large amount of data with huge columns then its fine.

Sorted Input: When you have large amount of data with huge columns then its fine by sorted the data.

sandy

• May 31st, 2015

Row by row: When you have large table you can use this option

Answer Question  Select Best Answer

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?

manoj2256

 Profile Answers by manoj2256 Questions by manoj2256

• Jan 23rd, 2015

While loading use table comparison, cache method and check input contains duplicate record. BODS will then consider the new record in cache table to be inserted and any duplicate will be then treated...

deepa

• 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.

Answer Question  Select Best Answer

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 ?

Prasanna

• May 5th, 2014

Use Table comparison Transform ,find out the difference and load into the target table.

selva

• 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

Answer Question  Select Best Answer

How do you aggregate data?

Deepak Kumar

• Jan 26th, 2013

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

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• 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...

Answer Question  Select Best Answer

What is an error handling framework?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Mar 12th, 2012

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

Answer Question  Select Best Answer

Ramesh

• 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

pavani_yerra

 Profile Answers by pavani_yerra Questions by pavani_yerra

• 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...

Answer Question  Select Best Answer

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

Ramesh Kumar Samy

 Profile Answers by Ramesh Kumar Samy Questions by Ramesh Kumar Samy

• 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

Answer Question  Select Best Answer

What is the difference between Query transform and SQl transform in BODI?

amuh1026

 Profile Answers by amuh1026 Questions by amuh1026

• 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.

gssharma_msc

 Profile Answers by gssharma_msc Questions by gssharma_msc

• 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...

Answer Question  Select Best Answer

pavani_yerra

 Profile Answers by pavani_yerra Questions by pavani_yerra

• 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...

Aparna

• Mar 19th, 2007

Data Integrator hierarchy is as follows                           ...

Answer Question  Select Best Answer

Explain What are Customized SQL Queries?

pavani_yerra

 Profile Answers by pavani_yerra Questions by pavani_yerra

• Jun 18th, 2010

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

Answer Question  Select Best Answer

Why is Bulk loading faster than normal loading in BODI?

pavani_yerra

 Profile Answers by pavani_yerra Questions by pavani_yerra

• 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...

Answer Question  Select Best Answer

What transforms do you use to implement SCD Type II in DI ??

pavani_yerra

 Profile Answers by pavani_yerra Questions by pavani_yerra

• 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

Answer Question  Select Best Answer

How we will implement Full outer join in BODI?Explain with some examples?

gssharma_msc

 Profile Answers by gssharma_msc Questions by gssharma_msc

• 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....

Answer Question  Select Best Answer

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

gssharma_msc

 Profile Answers by gssharma_msc Questions by gssharma_msc

• Feb 27th, 2008

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

Answer Question  Select Best Answer