How to find a corrupted record in Multi file and how to correct the data if you know the correct value?

MJ

• Jul 4th, 2017

Considering scenario that record is not matching with metadata, thus it is bad, then you can find out it by using below method:-

m_dump

You will get record which is not matching with metadata & that will be faulty record

Vinit Singh Sheokand

• Jun 30th, 2017

This can be possible using m_dump with argument -show-partial

Answer Question  Select Best Answer

If a file contains 100 records and in that 5 depts. If I use rollup to process that file, How many time rollup will be called and how many times finalize will be called?

Ravi Kiran

• May 24th, 2017

Rollup will be called 100 times and finalize will be called 5 times if dept is the key

Bhuvana

• Mar 2nd, 2017

If the dept is used as key in the rollup then rollup function will be called 100 times and finalize function will be called 5 times (once for each group).

Answer Question  Select Best Answer

How to use rollup Component as Scan Component? On what condition Rollup component can be used as SCAN?

Jatin

• Apr 30th, 2018

Rollup will produce same number of columns as scan only in case when all the columns are selected as rollup key

Speedy

• Sep 22nd, 2017

As per my understanding, we cannot use rollup component as a scan component. The reason for this is Scan gets the cumulative data and can process the same number of output records as the number of inp...

Answer Question  Select Best Answer

Sort within group means data is already sorted on major keys and need to get the data sorted on minor keys.But if we already know tht the data is sorted on major keys then why donot we use SORT component and provide the key as {minor keys} in the SORT component? Why go for SORT WITHIN GROUPS

Ashish

• Oct 4th, 2020

As it will re-sort the data on the y key given ignoring the existing sort order

Aravind

• Sep 13th, 2020

When we use the already sorted data(based on field 1) to sort again with field 2 as you say, then the output will only be sorted with Field 2. In case of sort within groups, we will provide field 1 as...

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 3rd, 2008

Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml ...

sangee

• Nov 29th, 2006

Rollup summarize the group of data records.for eg: if we want the maximum value of the cust_id we will go for rollup.

Answer Question  Select Best Answer

mukund

• Dec 26th, 2006

Hi,lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.consider a lookup file "emp_detail" which is having the fields emp_id,...

vpnreddy

 Profile Answers by vpnreddy Questions by vpnreddy

• Nov 7th, 2005

Lookup File consists of data records which can be held in main memory. This makes the transform function to retrieve the records much faster than retirving from disk. It allows the transform component to process the data records of multiple files fastly.VPN Reddy

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 21st, 2008

DML are record format files used by the metadata files in Ab inition. DML can be embedded in the graph or can be a separate file with .dml extension.xfr file are transform functions used by graph.These are present in sandbox.xfr file can used to manipulate data nad compute new data from it.

K Nagi Reddy

• May 4th, 2006

DML describes the record format of the data. It is metadata.XFR is the set of business rules called a transform function.

Answer Question  Select Best Answer

Vishal

• May 7th, 2006

Broadcast - Takes data from multiple inputs, combines it and sends it to all the output ports.   Eg - You have 2 incoming flows (This can be data parallelism or component parallelism) on Bro...

K Nagi Reddy

• May 4th, 2006

replicate generates multiple straight flows as the output where as broadcast results single fanout flow.replicate improves component parallelism where as broadcast improves data parallelism.

Answer Question  Select Best Answer

DilipPanda

 Profile Answers by DilipPanda Questions by DilipPanda

• Apr 4th, 2010

Finalize function of SCAN Component is called for each record for  a group where as for rollup component it called only once.

satish kumar

• Apr 23rd, 2006

Roll up generates data records that summarizes group of data records the rollup can be used to perform the data aggregatuin like sum,avg,max,min etcScan component generates a series of cumulative summary records such as successive yera to date totals for group of data records

Answer Question  Select Best Answer

jagan

• Nov 16th, 2011

A semi-join returns rows from one table that would join with another table without performing a complete join. It doesn't have explicit syntax. Eg : semi join to evaluate an exists sub query {gesh...

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 6th, 2006

in abinitio,there are 3 types of join...1.inner join.        2.outer join         and 3.semi join.for inner join 'record...

Answer Question  Select Best Answer

Sachin

• Sep 4th, 2007

There are many ways to improve the performance of the graph. It also depends on a particular graph, the components used in it. In general the following tips can be used for improving perform...

prakash

• Aug 9th, 2006

hi sunny,wat u said is right.

Answer Question  Select Best Answer

lavanya J

 Profile Answers by lavanya J Questions by lavanya J

• Jun 9th, 2008

reformatjoinfilter by expressionsortrolluppartation components.

mukund

• Dec 7th, 2006

Hi gayathri,  We cannot say strightly that only certain componets only we have to use,it depends on business requirement,functionality. most frequently we use FBE,REFORMAT,ROLLUP,LOOKUP(LOOKUP_LO...

Answer Question  Select Best Answer

Satish Kumar

• Jun 9th, 2007

Hi Praveen,In Ab Initio there is no In Built Schedular in the GDE...Most of them are using cron tab or specific tools for scheduling 1)AutoSys or2)Maestro.

ramu

• Feb 19th, 2007

You dont have schedule in abinitio unlike informatica here in this tool we need to buy the third party tool namely autosys for scheduling

Answer Question  Select Best Answer

Himanshu Poddar

• Sep 23rd, 2015

What is the Ab Initio certification name for beginner?

ashutosh ojha

• Jan 9th, 2007

No it is not true they indeed offer certification and the cost is 1200$ .

Answer Question  Select Best Answer

mukund

• Dec 22nd, 2006

Hi visitor,  i've very less information about datastage,but let me differentiate abinitio with informatica,which are two major ETL tools in present market today Both tools are fundamentally ...

visitor

• Dec 15th, 2006

Mukund, What are the advantages of Ab Initio over Data stage Px? You seem very knowlegeble.  Thankx.

Answer Question  Select Best Answer

mukund

• Dec 22nd, 2006

Hi,max-core is very essential parameter in componets like sort,rollup,scan etcmax-core gives the amount of momory which a component uses to process data before spilling to disk ie we need to have an o...

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 15th, 2006

Most of the time you will not touch the max core value ! even though some one ask in interview strght way say most of the time we use default value.

Answer Question  Select Best Answer

How to filter the records by using Reformat?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Thru select

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

We can also use the Reformat feature output_index and output_indexes. If you have more filter condition then increase the no of count and use the if else condition with the Priority assignment. ...

Answer Question  Select Best Answer

Girivardhana Reddy

• Oct 5th, 2006

 You can truncate the table using one of the following components: Run SQL, Truncate Table, Update Table. 

kalyan

• Mar 16th, 2006

There are many ways to do it. 1. Probably the easiest way is to use Truncate Table 2. Run Sql or update table can be used to do the same thing 3. Run Program

Answer Question  Select Best Answer

phani

• Oct 12th, 2006

for partition by key it internally generates the hash code. through that i distributes the data records.round robin what they said was correct

kalyan

• Mar 16th, 2006

Partition by Key - Distribute according to the key value Partition by Round Robin - Distribute a predefined number of records to one flow and then the same numbers of records to the next flow and so o...

Answer Question  Select Best Answer

seemabuchhada

 Profile Answers by seemabuchhada Questions by seemabuchhada

• Mar 14th, 2014

One table can only have one clustered Index (When we create primary key on table,oracle automatically creates Clustered index on that column) but It can have many non clustered index, approximately 250

Tushar

• Oct 5th, 2007

Clustered Index creates physical order on the table based on the defination given. You can only have one clustered index.

Answer Question  Select Best Answer