When can we go replicate and when we cannot go broadcast components?What is the advantage & disadvantage of replicate?What is the advantage & disadvantage of broadcast?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Nov 15th, 2010

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

Answer Question  Select Best Answer

What is mpjret? Explain about the uses of mpjret. How to use mpjret?

khaleel.peace

 Profile Answers by khaleel.peace Questions by khaleel.peace

• Mar 1st, 2011

The variable $mpjret will hold the return status of Abintio graph.Echo $mpjret will tell if the is successful or failed.0 means sucess and any other number means failure.

Answer Question  Select Best Answer

arunsin

 Profile Answers by arunsin Questions by arunsin

• Mar 13th, 2011

Force_error()  function can be used within the xfr to abort the graph. Remeber to keep the transform component with 'Abort on first reject'.Also, specific error messages can be captured from the error port (Never abort).

Answer Question  Select Best Answer

Mayank

• Jul 18th, 2011

Give the path of .xfr file in AB_DM_DEFS as graph input value parameter.

Mayank Bansalcom

• Jul 18th, 2011

You can include the transform in test. transer using AB_DML_DEFS in Input Value parameter of Graph..

Answer Question  Select Best Answer

palinindia

 Profile Answers by palinindia Questions by palinindia

• May 20th, 2011

Data Lineage

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

chandrasekhar

• May 10th, 2012

1.Perform inner join for both file1 & file2
2.perform sort on dept id then do Roll up
3.perform inner join for roll up o/p and file3
4.finally you will get required result

Answer Question  Select Best Answer

On which parameter based broadcasting partition distribute the records to the outputs?

priti

• Jun 5th, 2012

There is no parameter in broadcast. It simply combines all the records from input ports to a single flow, and copies it to each of its output flow partition

Answer Question  Select Best Answer

How to write the script in Abinitio by using unix?

Alok Sahoo

• Nov 15th, 2012

You can create a script in UNIX in the general way like you are writing a shell script.

Answer Question  Select Best Answer

what is a Framework in abinitio all about? Can anybody explain me in detail about what an abinitio developer in general does in his job?

PLMS

• Mar 29th, 2013

The expected roles of abinitio developer has been below: i) Know how to work in Abinitio products GDE,EME,Co>Op & good exposure to unix scripting to create wrapper scripts & execute basic commands. ii...

Answer Question  Select Best Answer

Hi All,
I need few suggestion from ETL regarding certification programs.

I have 2.5 years of exp. as Abinitio Developer(ETL). I am on the bench and waiting for a project. Meanwhile I want to gain more knowledge on ETL and I am planning to do certification program. but, I have lot of confusion and doubts regarding the certification programs in ETL area.

Could anyone...

pmovva

 Profile Answers by pmovva Questions by pmovva

• Oct 3rd, 2014

Hello Raj,

Ab-Initio Certifications are only available in United States which can cost around $3-4k. Residents outside states dont have this privilege. Presuming that you are in India, I would recommend you to go-ahead with Teradata SQL and Oracle SQL Certifications.

Answer Question  Select Best Answer

How to find the schema either Star or Snowflake Schema in our project?

kishore

• May 4th, 2015

Based on joins between fact table and dimension tables

Answer Question  Select Best Answer

Suhail

• May 27th, 2015

${} substitution is similar to $ substitution except that the parameter must be preceded by curly brackets. If we talk about these in parameter definitions then - 1. If the interpretation is $ subst...

Answer Question  Select Best Answer

How does the Index value come from in Normalize and when the vector element is not fixed length how does the length of() function in Normalize work

mohankrishna

• Apr 8th, 2016

Use the length_of(in.vector) in length function of normalize component.

Answer Question  Select Best Answer

Which version of ab inito works with hadoop with push down mechanism (Job gets executed on hadoop). Describes how it works.

Gautam

• Jun 20th, 2016

Any version of Abinito GDE:3.1.6.1 and Co-Op :3.1.6.6

Answer Question  Select Best Answer

Can you please help me to understand how to connect to belonging to different database
1) How can we create have 2 dbc in same environment (Here users are different so think it would be easy to have dbc as its same server(IP))
2) What if the server are different machine how can we connect same abintio instance.

Sampath

• Oct 18th, 2016

We can parameterise the db user and based on the condition, we can export the user to a variable and we can use the variable in dbc file.

Answer Question  Select Best Answer

What is Dependency Analysis? Why it is done? Example with an example?

Rayan

• Dec 7th, 2016

Dependency analysis is done to identify the Code analysis and data lineage, Quality Control and Accountability. It saves our time to understand better the flow of graph and data.

Answer Question  Select Best Answer

What are HLD and LLD documents? What do they contain?

Sridharan Hari

• Mar 8th, 2017

HLD -- High Level Design High Level Design (HLD) is the overall system design - covering the system architecture and database design. It describes the relation between various modules and functions of...

Answer Question  Select Best Answer

If data is still loading into table what mode will you use to see the data?

notjustaprettygirl

• Jul 24th, 2017

API mode. The main difference between the two modes - API and utility is that API commits after predetermined number of transactions where as utility commits only after all transactions have been processed. Hence API is slower but recovery is faster and utility is faster but recovery is slow.

Answer Question  Select Best Answer

What is the difference between global and local parameters

Srikanth

• Nov 10th, 2017

Global variables we can use all over the package where as local variable is for procedure or functions only

Answer Question  Select Best Answer

What do you mean by Data Directory in abinitio?

Amol

• Dec 2nd, 2018

It is a directory used while creating the private projects, You would perform this by Command line or through GDE.

Answer Question  Select Best Answer