Instead of m_ filename if we do a rm filename by mistake and want to recover that control file, how do we do it? can it be done using a checkpoint, if yes how and is there another way?

Siva Parvathi

• Jun 5th, 2017

If only control file got deleted, simply it can be created using m_touch
As data remains in partitions, it automatically can point to corresponding partitions

Tanz

• Mar 21st, 2012

If data files are present simply do m_touch control file name

Answer Question  Select Best Answer

If a file contains 100 records and in that 5 depts. If I use rollup to process that file, How many time rollup will be called and how many times finalize will be called?

Ravi Kiran

• May 24th, 2017

Rollup will be called 100 times and finalize will be called 5 times if dept is the key

Bhuvana

• Mar 2nd, 2017

If the dept is used as key in the rollup then rollup function will be called 100 times and finalize function will be called 5 times (once for each group).

Answer Question  Select Best Answer

I have data like below.
source file:
EmpID sal
A 1000
B 2000
C 3000
D 4000

Lookup File
EmpID
A
B

Output File
EMPID Sal
C 3000
D 4000

I want empId, sal of employees those not present in lookup file

saigoud

• May 16th, 2017

Use the components lookup and Filter_by_expression and write the code
lookup_count("Lookup File",empid)==0 in FBE you will get this output

Garima Takur

• Nov 27th, 2016

Use FBE component and give he select condition as !(lookup_match("lookup_file",in.emp_id) the output in select port will be the required result

Answer Question  Select Best Answer

What is behavior of join with multifiles if I use Join via common key in both files and if the key is different what is the result?

swapnil5291

 Profile Answers by swapnil5291 Questions by swapnil5291

• May 12th, 2017

As per my understanding there will be two scenarios here, if multi-files are partitioned based don key to be joined upon then by join key with same data type it will produce normal join results depend...

• May 2nd, 2017

Use the override-key option in join parameter, but the key should be of same data type. It will perform as per join type you mentioned

Answer Question  Select Best Answer

What are HLD and LLD documents? What do they contain?

Sridharan Hari

• Mar 8th, 2017

HLD -- High Level Design High Level Design (HLD) is the overall system design - covering the system architecture and database design. It describes the relation between various modules and functions of...

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

Difference between a phase and checkpoint as far as i know it something related with how temporary files containing the data landed to disk is handled.that is phases are used to break up a graph so that it does not use up all the memory , it reduce the no of component running in parallel hence improves the performances (used for performance fine tuning, by managing the resource in perfect manner)Check...

Mayank

• Dec 28th, 2016

Short answer The essential differences between a phase and a checkpoint are their purpose and how the temporary files containing the data landed to disk are handled: Phases are used to break up a...

preethi

• Oct 16th, 2016

The component immediately before the phase break writes the data into a temporary file in the layout of the component after the phase break

Answer Question  Select Best Answer

Rose Mary

• Dec 24th, 2016

When a stored procedure is executed for the first time, SQL Server optimizes and compiles it. A query plan is created and stored in cache for the stored procedure. On subsequent executions, SQL Server...

siddharth ranga

• Sep 29th, 2005

Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/deletion/addition of data. Due to the heavy modification activity the execute plan becomes outdated an...

Answer Question  Select Best Answer

What is Dependency Analysis? Why it is done? Example with an example?

Rayan

• Dec 7th, 2016

Dependency analysis is done to identify the Code analysis and data lineage, Quality Control and Accountability. It saves our time to understand better the flow of graph and data.

Answer Question  Select Best Answer

Can you please help me to understand how to connect to belonging to different database
1) How can we create have 2 dbc in same environment (Here users are different so think it would be easy to have dbc as its same server(IP))
2) What if the server are different machine how can we connect same abintio instance.

Sampath

• Oct 18th, 2016

We can parameterise the db user and based on the condition, we can export the user to a variable and we can use the variable in dbc file.

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

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

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

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

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

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

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

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

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 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