Mahesh

• May 26th, 2021

For data parallelism, we can use partition components. For component parallelism - its when i/ file ---> rollup(mfs layout) --> output . Here practically there are 4 copies of components running ...

Gouse

• May 26th, 2016

The component without sorted input because sort component breaks pipeline parallelism.

Thanks
Gouse

Answer Question  Select Best Answer

veer

• Jul 17th, 2023

Rollup Summarizes data by grouping records and applying an aggregate function to each group. The finalize transform function is applied to a group of records to produce an output record. The number...

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 8th, 2014

Roll up: Scan: Aggregate Summary Cumulative Sum...

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

arya

• Oct 5th, 2012

Ab Initio Graphical Development Environment
Version 3.1.1 Build ID 427346

Co-Operating System
Version 3.0.5.5

Allen

• Oct 1st, 2012

Ab Initio Graphical Development Environment
Version 3.0.5.3
Build ID 411497

Co>Operating System
Version 3.1.2.6

Answer Question  Select Best Answer

i having 1000 records in in0 file.
i want first 250 records into out0 file,
next 250 (250 to 500)records into out1 file,
next 250(500 to 750) records into out2 file,
last 250(750 to 1000) records into out3 file using partition components?

Prajna

• Sep 3rd, 2013

It can be done by Partition-by-round-robin giving the block-size=250

shan

• Oct 11th, 2012

Partition by expression:next_by_sequence = 250

Answer Question  Select Best Answer

If we give NULL key in scan component what will be the output and in dedup with keep parameter as unique?

Amaan Sajid Ansari

• Nov 14th, 2018

For unique only, the output for Dedup will be 0 records. While if you keep it to first or last it will be first or last record of each partition respectively.. While in case of scam it will treat the ...

Krushna

• Sep 6th, 2018

If key is {} in sort then Data will not get sort. It gives as it is data which is received from in port

Answer Question  Select Best Answer

What is the alternate component for output indexes?

Manish Sharma

• Jul 8th, 2020

We can achieve it by combing replicate and filter by expression.

Rishiraj Shengule

• Jul 28th, 2016

Filter By expression is also an alternate option

Answer Question  Select Best Answer

Input file
col1
1
2
3
4
5
6
7
8

output file
col1 col2 col3 col4
1 2 3 4
5 6 7 8

How to achieve this?

Anand Kishore

• Oct 7th, 2022

Use round robin with sequence 3

Mahesh

• May 26th, 2021

Redefine component with output dml as
record
decimal("x00") col1 = 0;
decimal("x00") col2= 0;
decimal("x00") col3 = 0;
decimal("x00") col4 = 0;
end;

Answer Question  Select Best Answer

I am having input column as runs with values
3
2
4
6
0
1
0
3
2
6
0
0
4
1
1
2
3

In output I want over number on Over column and corresponding runs on Runs column
Expected o/p is:-
Over Runs
1 2
1 4
1 6
1 3
1 0
1 1
2 0
2 3

Ahmad Ali Quraishi

• Jan 6th, 2024

Reformat:

let int over=0;
out :: reformat(in)
begin
if(next_in_sequence()%6==1)over=over+1;
out.over :: over;
our.run :: in.run;
end;

Anurag

• Nov 22nd, 2022

Let decimal(2) over=0;
out::reformat(in)=
begin
if (((next_in_sequence()-1)%6)==0)over=over+1;
out.over :: over;
out.run::in.rec;
end;

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

GdE runs on co op..whatever u run here on GDE runs with the help of co-op.

EME is for version control of GDE developed projects n plans.Its not that much necessary to have EME..i think..

girish.v

 Profile Answers by girish.v Questions by girish.v

• Dec 19th, 2010

GDE is Graphical Development Environment where user creates graphs(It is having GUI environment installed in wondows).Co>Op system is used for running the developed graphs either in Unix or in Wind...

Answer Question  Select Best Answer

venkat_jaksani

 Profile Answers by venkat_jaksani Questions by venkat_jaksani

• Jun 18th, 2010

.dbc file contains all the connectivity info which the user needs to connect to the database. dbc means database configuration file. It will contain the server name userid password type of db stuffs l...

dash_c00l

• Oct 31st, 2007

.dbc file basically helps abinitio coops to connect to database. It includes all the required database parameter and other default value respective to it. you can modify them.However .cfg is file is u...

Answer Question  Select Best Answer

Sandeep

• Sep 11th, 2017

Local and Input parameter
local are handled by users while input parameters are handled by developers.

saigoud

• May 16th, 2017

1) Local parameter and 2) Global parameter

Answer Question  Select Best Answer

What are the two types of .dbc files

madhu922.m

 Profile Answers by madhu922.m Questions by madhu922.m

• Dec 21st, 2011

.dbc file is database configuration file. In this file, information to connect the database is given.

Types of files:
1. Fixed length file
2. Delimited file

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 14th, 2009

We don't have diff types of dbc file. We have only one dbc file which is used to connect the component in the GDE with particular database

Answer Question  Select Best Answer

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Dec 16th, 2009

anujaja, use only one dedup sort. in dedup sort use the select statement "next_in_sequence > 1" and use keyless Dedup "{}".  With keep paramete "last". this will remove trailer, you will get all the body part from the "dup" port-Shambhu

anujaja

 Profile Answers by anujaja Questions by anujaja

• Aug 25th, 2009

You can also use a keyless Dedup with keep parameter as first.This will put header in output port and rest of the record on Dup port . Then connect dup port again with another dedup and use Keep parameter as last this will remove trailer as well.

Answer Question  Select Best Answer

biyyanimv

 Profile Answers by biyyanimv Questions by biyyanimv

• Sep 2nd, 2008

If you have to perform full outer join then you should go for join not for lookup.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 17th, 2008

Lookup should be used only to speedup the graph execution but here there is catch if the lookup file is small then only we should used lookup because when the graph start executing it will load whole ...

Answer Question  Select Best Answer

suren

• Apr 16th, 2012

We can achieve that through the rollup ...

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 8th, 2009

Rollup will help to avoid the duplicate without using dedup component.It takes the first record and reject the rest

Answer Question  Select Best Answer

Amruta

• Jan 9th, 2021

What I am thinking is to sort the data 1st and then use scan component--Give key and define temp variable which will generate sequence per group.....in output select seq number as 1...This will reduce duplicates and give distinct record at output

karti

• Aug 31st, 2020

It works if input is like below only
i/p
1
1
2
2
2
3
3

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

PLMS

• Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Malini

• Apr 3rd, 2012

Code
 

Answer Question  Select Best Answer

How can I set up email notification graph failure in Ab Iniio to send ,which should include error message and componet details which caused the failure

M Farhan

• Dec 31st, 2018

In end script for mpjret !=0
use mail command from unix

Kiran

• Apr 22nd, 2015

We can send the mail by using component of Send E-Mail notification.

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