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

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

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

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

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

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

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

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

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

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

How to find a corrupted record in Multi file and how to correct the data if you know the correct value?

MJ

• Jul 4th, 2017

Considering scenario that record is not matching with metadata, thus it is bad, then you can find out it by using below method:-

m_dump

You will get record which is not matching with metadata & that will be faulty record

Vinit Singh Sheokand

• Jun 30th, 2017

This can be possible using m_dump with argument -show-partial

Answer Question  Select Best Answer

If data is still loading into table what mode will you use to see the data?

notjustaprettygirl

• Jul 24th, 2017

API mode. The main difference between the two modes - API and utility is that API commits after predetermined number of transactions where as utility commits only after all transactions have been processed. Hence API is slower but recovery is faster and utility is faster but recovery is slow.

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

If I am having two table- customer and transaction. I am having 100 rows and 10 columns and I want to perform the join with NULL key, then how much output records I will get?

nagesh

• Aug 17th, 2017

Cartesian product :100*10= 1000 records

Kiran

• May 8th, 2015

If you are passing null key to Join component , you will get Cartesian product (input1 records X input2 records).
Thanks in Advance.

Answer Question  Select Best Answer

I have a scenario:
Input file
Col1 col2
1 A
2 B
3 C
4 D

and desired output should be like below:
col1 1 2 3 4
col2 A B C D

Could you please help

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 17th, 2017

String_join(Accumulation (in.id),"");
Try this in rollup
Hopefully it works

Jyotiprasad

• Aug 12th, 2017

Use meta pivot or nomalize component

Answer Question  Select Best Answer

How to find corrupted record in multifile?

Monika Rani

• Aug 25th, 2017

M_dump dml file -show-partial -partition n

by giving value of n, check for each partition

Preetilagna Dash

• Aug 22nd, 2017

M_dump dml fileurl -show-partial

Answer Question  Select Best Answer

SP

• Aug 31st, 2017

Lock is a version control mechanism in Abinitio. It is used to maintain data/code synchronization between EME and multiple sandboxes. It avoids to modifying the code simultaneously be different users at the same time.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 18th, 2008

Lock mechanism is used by EME datastore to avoid confusion in the version control of a graph basically locking give a exclusive permission to modify and save it for a particular users and prevents other from making changes to the same file.

Answer Question  Select Best Answer

How to delete a record from a multifile?

Sandeep

• Sep 10th, 2017

Linux command:
vi `m_expand -native file_name`
it will expand the control file and allow us to edit in all partition.

SP

• Jun 5th, 2017

a. Build a duplicate graph with the same logic that processes the file b. Select Never Abort for that component where a failure may occur. c. Arrange Reject port for that component and run the grap...

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

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