What are Wrapper scripts? What does it contain?

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jul 19th, 2010

Wrapper scripts are unix scripts,they also known as calling scripts.they used to run the deployed scripts.in the order what se can specify in the unix script

Answer Question  Select Best Answer

How can you set the parameters to call the graphs?

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 17th, 2012

Edit > parameters or F11

Answer Question  Select Best Answer

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

.pset file is an input values or input parameters set file. By using the air sandbox run command we can run the .pset file. Internally calling the .mp file and passing all the inputs parameter during run time.--Shambhu

Answer Question  Select Best Answer

What is Factless Fact?

sree

• Aug 19th, 2011

The fact which is not having any measures(like Quantity) are called factless fact

Answer Question  Select Best Answer

How do you use DB Lookup?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 26th, 2010

For DB Lookup you can use the componant Join with DB. This is very expensive operation in the Abinitio. If Join table caontain less data then first create a serial file and use as a lookup. OR go for abinitio Join.--Shambhu

Answer Question  Select Best Answer

Which component will be used to reduce the size of the file?

sweetramy

 Profile Answers by sweetramy Questions by sweetramy

• Oct 7th, 2010

You can use the Compress or Deflate component to reduce the size of the file.

Answer Question  Select Best Answer

How to get sort data in i/p by using single component in abinitio?

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by siva sankar pulivarthi

• Dec 28th, 2011

You can use sort component to get the sorted output.

--
Siva Sankar Pulivarthi

Answer Question  Select Best Answer

How can we login into the abinitio as a developer?

puneetdking

 Profile Answers by puneetdking Questions by puneetdking

• Sep 30th, 2011

If u have access to Development server provided by the firm u r working with, then you can log in as developer by giving host name (Dev server name), host type, connection method, your login id and password from Settings > Manage connection menu in abinitio tool

Answer Question  Select Best Answer

What is use of index in Reformat Component?

priyanka2000

 Profile Answers by priyanka2000 Questions by priyanka2000

• Jan 8th, 2011

Output_indexes in Reformat functions like a Partition.

Answer Question  Select Best Answer

Give some runtime errors which are commonly comming in your graph execution?

dilipkumar291

 Profile Answers by dilipkumar291 Questions by dilipkumar291

• Dec 15th, 2010

Nerver abort

Answer Question  Select Best Answer

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