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

titli_n_titli

 Profile Answers by titli_n_titli Questions by titli_n_titli

• Aug 14th, 2009

The below SQL Query can solve the purpose:select username from V$SESSION;

app1mxk

 Profile Answers by app1mxk Questions by app1mxk

• Dec 14th, 2008

Sp_who and sp_who2

Answer Question  Select Best Answer

arpit mathur

• Sep 29th, 2011

Hi Can u please explain it with example, i need to build the vector for comparison of the inputs records , if that records matches then i take the output

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 8th, 2009

Vector field is like an array which is used in C/C++.Its mainly used in normalize and denormalize component.

Answer Question  Select Best Answer

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Sep 8th, 2008

You can do anything in Ab Initio, depends on the logic you useSay there are 10 jobs 1,2,3,4,5 .. 10 and all the graphs are deployed as script.Suppose 1-4 graps should run at the same time and sequenti...

sreenivasamurthy

• Jun 19th, 2007

In ab initio there are no specific scheduling options as in informatica. What we can do is use cronjob options as in unix

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Aug 1st, 2008

As explained by Abishek, EME is the data repository(Datastore's data files)?as well a version controller compoent of ab initio software. It keeps track of obhects such as graph, dml, xfr, ksh and sq...

sreenivasamurthy

• Jun 20th, 2007

EME stands for Enterprise Meta Environment. It is nothing but like a repository in Informatica. It contains all the metadata i.e data related to graphs, dml, xfr, etc. It performs the following func...

Answer Question  Select Best Answer

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 6th, 2009

Give the parameters using edit parameter and make it as formal parameter that is run time parameter.Then in the DML eg. $AI_DML/abc_$parameter1.dmlAccording to the value of the parameter that particular DML will be called.

Guru

• Sep 4th, 2007

If DML changes dynamically in source we can handle it using "Conditional DML'But how it can be achieved in "parameterisation" and using "metadata". Please explain?

Answer Question  Select Best Answer

N MAHAMMAD RAFI

• Nov 24th, 2006

Hi GUYS, COMPONENTS>TRANSALATE>READ SAPARATED VALUES component ... U CAN USE THIS EXCEL FOR EXCEL SHEET...................THANKSRAFI CHENNAI

atish_ban

 Profile Answers by atish_ban Questions by atish_ban

• Apr 2nd, 2006

Make it csv formatted , deliminated file and read it thru input table comp.

Answer Question  Select Best Answer

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 8th, 2006

Every component in Ab initio has a memory of 7MB (anybody correct me if I'm wrong) except a few components like In-Memory components such as join, Rollup, Scan, join with DB etc., which uses an a...

atish_ban

 Profile Answers by atish_ban Questions by atish_ban

• Apr 2nd, 2006

It is maximum temporary scratchpad memory allowed for execution of a in-memory component/per partition.

Answer Question  Select Best Answer

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 10th, 2014

There are a lot of options in Ab Initio. To get the report at Component level,Graph level ( Log port, AI_SUMMARY files). Ab Initio can even generate reports at the transformation level how many times ...

know_know

 Profile Answers by know_know Questions by know_know

• Feb 21st, 2011

There is a log port in every component available. You can use this port to generate reports.

Answer Question  Select Best Answer

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Jun 29th, 2009

Use lookup_count for finding the duplicates and lookup_next for retrieving it.If lookup_count (string file_label, [ expression [ , expression ... ] ] )>0lookup_next ( lookup_identifier_type lookup_id, string lookup_template ) Njoi!!Abhi - fresh as dew!

pradeep

• Nov 16th, 2006

Lookup_next function is used for retrieving duplicates records of that particular record

Answer Question  Select Best Answer

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Feb 3rd, 2010

For ASCII formats write the DML as below.cust_id decimal(8)...For EBCIDIC formats write the DML as below.ebcidic cust_id decimal(8)...The delimiters varies in each and every ebcidic formats send from source files.  But Its generally hexadecimal embedded.

AprilBlue

 Profile Answers by AprilBlue Questions by AprilBlue

• Jan 10th, 2007

Ascii vs. EbcdicWhen you view  your data does it have different charaters inbetween that do not look ASCII?  If so, then in your record format type the following:ebcdic record record details...

Answer Question  Select Best Answer