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

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

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

Rajat Singh

• Feb 20th, 2013

Skew of a partition is the amount by which its size deviates from the average partition size

vSudheer

 Profile Answers by vSudheer Questions by vSudheer

• Mar 3rd, 2012

statistically, skew represent distribution of data.. when all partitions share equal amount of data, it is the best use of portioning. This can be achieved by partition-by-roundrobbin or by using equ...

Answer Question  Select Best Answer

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

venkat_jaksani

 Profile Answers by venkat_jaksani Questions by venkat_jaksani

• Jun 17th, 2010

If string conains the alphanuemica data the decimal-strip will remove the alpanumeric data but the decimal(length) will not remove alphanumeric data.Please let me know If I am wrong.

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Mar 29th, 2010

Decimal_lrepad(string name, decimaldata type length) decimal_lpad(string name, decimaldata type length)

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

M_dump is used to view data as in graphs

m_dump [-dml] [-file]

Nv

• Feb 3rd, 2012

Cat file.dml will work fine but it wont display the record format in a formatted way..You can think of m_dump as "view data in formatted " manner.

Answer Question  Select Best Answer

Ketan Khot

• Jan 12th, 2018

Go with the profile transform. Run your graph with profile transform option to track which statement or function is taking more time so you can updated the code accordingly. Go with graph tracking o...

Mukund

• Dec 28th, 2017

For point no. 2) lookup_local (Which is now replaced with lookup_first_local) can be used efficiently only when data is available in same partition of parent lookup file else it will give NULL results

Answer Question  Select Best Answer