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

Suppose we have two input files A and B both having different columns & data, for example A having 1 2 3 4 columns and B having W X Y Z, How to get output as 1 2 columns from A and W X Y from B

Khaja

• Apr 11th, 2018

Reformat is used to drop the fields. By using reformat drop the fields from two files and get the output as required give input to fuse.

gouse

• May 27th, 2016

We have to specify 1,2 columns from A w,x,y from b in fuse component o,p dml. then combine two files
By using fuse components. By using we cont achieve this op

Answer Question  Select Best Answer

I have fields like a10 b20 c123
If we give numeric value (any number) as key in sort component, what would be the expected result?

Do we get a sorted order? or Does the sort component spits an error?

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 17th, 2017

Sort the data based on ASCII value

Anil dara

• Aug 17th, 2017

In sort component for example i have 1-10 numbers i specified in the sorted key as 5 it throws an error called "error in key specifier {5},filed "5" not found in record.

Answer Question  Select Best Answer

How we can make N number (say 50) copies of a file in GDE without using replicate?

irfan1patel1

 Profile Answers by irfan1patel1 Questions by irfan1patel1

• Nov 21st, 2017

This is a strange requirement as in ideal world no-body wants duplicated data in their server. To answer the question I can suggest below two solutions : 1) In the end of the graph call a Run_progra...

Shabnam

• Jan 18th, 2017

We can use Normalise component with the length value=50.

Answer Question  Select Best Answer

If a DML is changed, how to find out the impacted objects using a command?

sandeep

• Sep 11th, 2017

"air object uses" has been replaced by "air object referencing-files"

Jagnyadatta Sena

• Jul 26th, 2017

We can use all below:
air uses
air object uses .

Note: If dependency analysis is not there for the checked-in object, these commands will not show any output

Answer Question  Select Best Answer

How to get each partition count and total count of a multi file?

Mahesh

• May 26th, 2021

M_wc gives you the number of records in all the partitions and als a total at the bottom

Shubham

• Sep 18th, 2019

Reverse the Command... m_wc

Answer Question  Select Best Answer

I have a record like below:
avi,mahi,virat,mahi,avi,virat,mahi,virat,avi
Output should be:
avi1
mahi1
virat1
mahi2
avi2
virat3
mahi3
virat4
avi3
Please suggest how can I achieve this.

neha.nagare

 Profile Answers by neha.nagare Questions by neha.nagare

• Apr 26th, 2018

Flow I/p ->normalize ->scan->o/p We can achieve this by using normalize and scan component ,make vector by using string_split function and assign size of the vector to the length function of the no...

Sandeep

• Mar 25th, 2018

Use scan component using check sort attribute as false(maintain order-false)
then use name as key and for sequence number use count(in.name)

Answer Question  Select Best Answer

Hi,
I have a data like 1,a,b,c,2,d,e,f,g
required output is in two fields:
field1,field2
-----------------
1,a
1,b
1,c
2,d
2,e
2,f

Yash Chaudhari

• Jan 15th, 2025

Use only 2 components IP ---> REFORMAT ----> FBE ----> OP in reformat transform: /*Reformat operation*/ let string("") f_num = "0"; out::reformat(in)= begin if(string_is_numeric(in.str)) f_...

Ravishek

• Feb 3rd, 2024

Hi Aditya , can you provide actual answer of it?

Answer Question  Select Best Answer

Preeti

• Sep 25th, 2013

M_db gendml dbc_file [options] -select sql-select-statement

vamsi

• Nov 21st, 2012

M_db < dbc name > -table < table name >

Answer Question  Select Best Answer

arunsin

 Profile Answers by arunsin Questions by arunsin

• Mar 13th, 2011

Adding to all the point mentioned by others -- Thumb Rule is to prefer componet solution to a problem compared to logical solution.- Use Oracle hints and Ab Initio Hints (ABLOCAL utility for lower ora...

aditya_kundu

 Profile Answers by aditya_kundu Questions by aditya_kundu

• Sep 18th, 2010

I would like to add couple of more points to the already given explanations:1. Try to use lookups for joining instead of join if you have huge no. of records in one flow and relatively less no. of rec...

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 21st, 2008

Limit  parameter contain an interger that represents a number of reject eventsthe ramp parameter contains a real number that represents a rate of reject events in the number of records processed. 

sangee

• Nov 29th, 2006

We will go for ramp limit to set the reject threshold for the record being processed.

Answer Question  Select Best Answer

PeeD1

 Profile Answers by PeeD1 Questions by PeeD1

• Apr 16th, 2009

When there are duplicate keys in either or all of the joined datasets the result is a cartesion product. This is termed as Cartesian Join in Abinitio.Eg:If there are two input datasets for a join func...

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Jan 3rd, 2008

 join two tables without join key , that is crossproduct.

Answer Question  Select Best Answer

nmalik50

 Profile Answers by nmalik50 Questions by nmalik50

• Jul 7th, 2009

The name of the SQL language is TSQL

MadhuriKumar

 Profile Answers by MadhuriKumar Questions by MadhuriKumar

• Apr 24th, 2008

SQL stands for Structured Query Language.

Answer Question  Select Best Answer

basuatrayee

 Profile Answers by basuatrayee Questions by basuatrayee

• Jan 30th, 2008

There can be numerous sandboxes for a project but there should be only one sandbox associated with EME for a project.

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Dec 31st, 2007

We can have any no of sandboxes, sand box is nothing but users work area where each user  will get copy of the project & do the modifications acc.

Answer Question  Select Best Answer

chandan

• Feb 7th, 2007

In SW world fencing means job controlling on priority basis. In AI it actually refers to customized phase breaking. A well fenced graph means no matter what is source data volume process will not cough in dead locks. It actually limits the number of simultaneous processes.

Rajeev M Sankarathil

• Dec 6th, 2006

I think he is refering to "Phasing" only.Phasing:- Its a way to manage the resource and avoid "deadlocks" in the Abi run. it limits the number of simultaneous processes by breaking up the graph into different phases, only one of which is running at any given time.

Answer Question  Select Best Answer

mukund

• Dec 15th, 2006

yeah,  abinitio is a combination if GDE(graphical development environment),co^operating system,and EME(enterprise metadata environment)each have its own importance and are inter-related.generally...

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

abintio is like blub ! co-op is like current(transformer) ..bulb will glow only when current is passsed ..

Answer Question  Select Best Answer

amitesh87

 Profile Answers by amitesh87 Questions by amitesh87

• Apr 2nd, 2009

From UNIX you can go to pset folder in your sandbox then type??air sandbox run abc.pset Whatever may be your psets name or just call graph script .ksh

mahendra patnaik

• Feb 5th, 2007

Hi,it is possible in Unix... first you have to go to the directory where your deployed script is saved for that particular graph then execute the shell script by using the following command.../.kshI hope it will help you ...regards,Mahendra

Answer Question  Select Best Answer

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jun 12th, 2010

API mode is for more diagnostic purpose for retriving the data from db means like selecting perticular fields, like retriving the data relatively according to the constraints.  Whenever we select...

subhajitpalit

 Profile Answers by subhajitpalit Questions by subhajitpalit

• Dec 11th, 2009

In API mode the data processing(load/update/insert/delete) is slow, however other process can access the database tables during the update.Compared to above, Utility mode processing(load/update/insert...

Answer Question  Select Best Answer

mahendra patnaik

• Feb 5th, 2007

Hi,EME contains only the latest version graphs of your project. It is a area where single or multiple projects will stored. for checkin or check out the graph into the EME you have to look on to the...

sekhu

• Dec 22nd, 2006

sandbox --> is the personal work area and u will find only latest vesrons of the graphs.eme is like vss ! there u will find old and new versions of the graphs.when u check in / out the graph that will come into your sandbox area.hope this will help you..

Answer Question  Select Best Answer

HI,I've installed GDE 2.8 on windows Xp,and our database running as oracle9i,how do we install co-operating system... and on the same machine informatica server& client also running.does it matter of informatica software exists where abinitio gonna installed...pls do let me know the steps of installation process of Abinitio.Thanks,SindhuReddy

Suresh

• Feb 27th, 2017

Hi Vasu, I would like to use Ab initio in local machine. My OS is Windows 10. I am trying to install Abinitio co operating system environment using comparability mode, but not able to install as it is showing "Needs Windows NT 4.0"

gopal

• Jan 24th, 2007

Hi vasuInstalled in XP professional Abinito 2.10 co>op sys and 1.10.8 GDE version.I created dml and data in serial file.--dml is simpleas well as graph with FBE & out filei want to see data from file ...

Answer Question  Select Best Answer