Could you please explain me in details differences between Multi File s and Adhoc Files ?

Thanks in Advance.

gouse chpet

• Jul 15th, 2015

Collection of individual files is known as multifiles.
m_mkfs < control partition >< data partition >......

Collection of individual files having same dml is known as adhoc multi files.

anuvardhan

• May 18th, 2015

Collection of files is known as multifile.
collection of files having same dml function is known Adoc multifile

Answer Question  Select Best Answer

sathish18

• Aug 8th, 2015

When we invoke the script for the first time, the jobname is determined from graph or pset or plan name and the mp job command is invoked to create jobname.job file. So basically the job files is the ...

Shubh

• Feb 5th, 2015

.job file is a catalog file which is created as the same name of graph with extension of .job and it calls launcher which initiates process

Answer Question  Select Best Answer

Nikhil

• Aug 19th, 2015

How can we integrate Ab Initio with Jenkins. Have you done anything like that or read about it. I want to integrate them.

robbyuk

 Profile Answers by robbyuk Questions by robbyuk

• Mar 27th, 2013

Hi All,

I appreciate I am a late entry for this question. I think tools like Jenkins can be used for Ab Initio automation test harness. Please correct if I am wrong.

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

If you have one input file it have some thousands of records then how to Seperating the header and trailor records from the input file?

gouse

• Nov 1st, 2015

Record identifier with reformat or deduo sort or filter by expression.

Sagar Sali

• May 14th, 2015

1) If the header and trailor is denoted by some special separator like H or T, you can use filter by expression and condition like (rec_type != "H" and rec_type != T")

2) You can use 2 dedup component and in first comp, keep first and next use comp, keep last, so u can separate.

Answer Question  Select Best Answer

I have a serial graph with below sequence:
i/p -> sort(key1)->rollup(key1)->sort(key2)->rollup(key2)->normalise->o/p.

How do we improvise this graph?

gouse

• Nov 20th, 2015

By reducing number of sort components

raja

• Feb 10th, 2015

It depends on your input data.If you specify some of your input data will be more helpful. My suggestion is instead of using two roll up and two sort keys try to use it only one rollup with key1 and key2

Answer Question  Select Best Answer

How to generate sequence number in a multifile using next_in_sequence().

Sachin

• Feb 3rd, 2016

Next_in_sequence()*(this_partition()+1)

srinivasareddy

• Jul 21st, 2015

hi I think this will be help you if the mfs is 4-way if (this_partition() == 0)((next_in_sequence()-1))+this_partition()+1 else if (this_partition() == 1) ((next_in_sequence()-1))+this_partition(...

Answer Question  Select Best Answer

How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?

mk_44

 Profile Answers by mk_44 Questions by mk_44

• Feb 9th, 2016

I guess below code can help for 3rd max else 1st max for each group key. Input_file --> sort (descending) --> Rollup --> output type temporary_type=record decimal("") rank ; decimal("") sal ...

disha

• Jan 22nd, 2016

@Dinesh: but it is not taking care of the requirement, i.e. if there is no 3rd record, it should display the first highest sal. In the solution you mentioned it will display the second highest sal.

Answer Question  Select Best Answer

How to Join Data from Two Partitions of a Multifile in Abinitio..!

Hi,
I have a multifile having 8 partitions.
I want to join partition 1 and partition4 data.
Could someone explain the approach for the above requirement?

Thanks in advance,
Srikanth

Devendra Majhi

• Mar 19th, 2016

Use PBE to get partition 1 and 4 in seperate flows using this_partition=1 nd 4. Then use join

irfan

• Jan 13th, 2016

I guess, you should use this flow i/p -> FBE(this_partition() ==4 -> JOIN

Answer Question  Select Best Answer

How will you test the abinitio graphs?

Keerthi

• Mar 21st, 2016

Hi Juber Shaikh can you please explain in detail how can we use it

juber shaikh

• Sep 12th, 2013

You can use An Test Runner utility of Abinitio for testing purpose.

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

How can i sort the data using reformat component in Abinitio?

And Tut

• Apr 13th, 2016

You can first create a vector using the rollup component and then use the vector_sort function in the reformat and then expand the vector using normalize. I hope this helps

gouse

• Jul 12th, 2015

Using next_in_sequence inreformat transform function

Answer Question  Select Best Answer

I have a scenario like, I am getting a date field from input in MMDDYY format and I have to check for same year as processing year then I should pass "", else if the input date is to previous year to processing date and less than 0301 then I should pass Y.
How to check and process the date?

ahamed

• May 12th, 2016

Inputfile-->reformat-->outputfile
if((string_substring(in.indate),5,2)==string_substring(now(),5,2))""
else "Y";

mohankrishna

• Apr 8th, 2016

Use date function to get the current date and apply date_year function to get the processing year out of it. Do the same for input date to get the input year. If these two are equal set " " to output....

Answer Question  Select Best Answer

What is output index? How does it work in reformat?Does below function show Output index in useoutput:1:if(in.emp.sal

ahamed

• May 24th, 2016

If you want to send one input record to only one output port we can use the output index

geekrohit

 Profile Answers by geekrohit Questions by geekrohit

• Jul 14th, 2009

Output index function is used in reformat having multiple output ports to direct which record goes to which out port. for eg. for a reformat with 3 out ports such a function could be likeif (value==&#...

Answer Question  Select Best Answer

Using ROLLUP in Ab Initio, need to count the number of sites for each account e.g.

Input file:
SiteId, AcctId, Address
675765, 1, Smit Street
768768, 2, Orange Road
767876, 1, New Road
989898, 1, Jones Street
878787, 3, Ele Lodge
118768, 2, Red Street

Output:
AcctId, NoOfSites
1, 3
2, 2
3, 1

gouse

• May 26th, 2016

Rollup component key-acctid, no-of sites per accountid-count(acctid)

ahamed

• Mar 21st, 2016

Input file-->rollup{acctId}(input need not be sorted, out.acctid::in.acctid, out.count::count(in.siteId))-->Output file

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

manideepsai

• Jul 8th, 2016

In that case give the output path of A job to input of B job and then change the phases, run A job in 0 phase and then B in 1 phase.

raja

• Feb 9th, 2015

You can achieve this scenario by using plan with two graph task dependent on one another

Answer Question  Select Best Answer

What are extract and loading in strategies in ab inito and with what components we extract and load the data?

How can we do metadata level programming in dml itself to remove blank lines from a file

Shrikant Salunke

• Aug 27th, 2016

Sed with -i option makes changes in the file directly.

sed -i /^$/d dml_filename

aditya

• Oct 3rd, 2012

You can use unix command
sed /^$/d dml_filename > new_filename

Thanks
Aditya

Answer Question  Select Best Answer

Can i sort the data using reformat component in Abinitio, If yes,Then how?

Praveen

• Sep 18th, 2016

You would have declared the it as string. Ex: string(|)[integer(2)]. That is why it is sorted as how string would be sorted. Declare it as decimal. Ex: decimal(|)[integer(2)]. It will sort in the right way

Archisma Ghosal

• Sep 11th, 2016

Hi all,
I have found a problem with vector sort. Whenever we are trying to sort (17,16,5,89) it will give the value (16,17,5,89) whenever it is encountering 1 first it is ignoring 5. Can you help me with this?

Answer Question  Select Best Answer