How to find the schema either Star or Snowflake Schema in our project?

kishore

• May 4th, 2015

Based on joins between fact table and dimension tables

Answer Question  Select Best Answer

Suhail

• May 27th, 2015

${} substitution is similar to $ substitution except that the parameter must be preceded by curly brackets. If we talk about these in parameter definitions then - 1. If the interpretation is $ subst...

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

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

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

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

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

What is the difference between global and local parameters

Srikanth

• Nov 10th, 2017

Global variables we can use all over the package where as local variable is for procedure or functions only

Answer Question  Select Best Answer

What do you mean by Data Directory in abinitio?

Amol

• Dec 2nd, 2018

It is a directory used while creating the private projects, You would perform this by Command line or through GDE.

Answer Question  Select Best Answer

Suppose I have a project having many xfrs, I cannot check manually to understand the complexity of a xfr or graph, How can I check it, any command?
Can we understand its complexity just by checking dependency of a graph or XFR?

Sandeep

• Mar 25th, 2018

Air project analyze-dependencies relative_path -complexity
air project analyze-dependencies relative_path -complexity-details
air sandbox validate-graph path -complexity
air sandbox validate-graph path -complexity-details

Answer Question  Select Best Answer

There is a SFTP component placed at last of the graph.
Lineage report keeps on failing for every run because, the destination server cannot be considered.
It was success for all other components/subgraps in that graph.

Could you please help me here how can I get lineage report success?

anthati

• Oct 25th, 2018

Use document component to set graph lineage

Answer Question  Select Best Answer

How to generate DML from backend and front end?

inamdnik

 Profile Answers by inamdnik Questions by inamdnik

• Jul 3rd, 2018

Did you mean generate DML from UNIX(Back-end) and GDE(Front-end)?
If so then below is the answer
1. Generating DML from UNIX level
m_db gendml -table > $AI_DML/

2. Generating DML from Graph(GDE) level
You can create it from any components port tab--> Same As and Embedded radio buttons.

Answer Question  Select Best Answer

What is the main difference between max core and max memory.
Where we use this commonly?

Rahul Rasal

• Jan 25th, 2019

Max core : component max-core parameter determines the maximum amount of memory the component will consume per partition before it spills to disk.
max memory : Enables the collection of memory usage data for components.

Answer Question  Select Best Answer

I have an XML file with all the details of an employee. I just want to mask the firstname and lastname records as AAAA and generate the XML with all other fields including firstname and lastname. Please suggest on this

Ajanth

• Feb 19th, 2020

Read xml-->reformat (concat(masked chars+substr(name))-->write xml

Answer Question  Select Best Answer

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 8th, 2006

Packages are nothing but the reusable blocks of objects like transforms, user defined functions, dmls etc. These packages are to be included in the transform where you use them. For example, cons...

sekhar

• Sep 3rd, 2005

Need more elobirated with example .  thanks s

Answer Question  Select Best Answer

Ashim Dutta

• Jul 10th, 2005

ashimdutta@yahoo.com In case of reformat if the destination field names are same or subset of the source fields then no need to write anything in the reformat xfr unless you dont want to use any ...

srinivas

• Apr 3rd, 2005

1)If it is not already displayed, display the Transform Editor Grid.  2)Click the Business Rules tab if it is not already displayed.  3)Select Edit > Add Default Rules.    

Answer Question  Select Best Answer

chvignesh

 Profile Answers by chvignesh Questions by chvignesh

• Dec 8th, 2006

Foreignkey is a primarykey in other table which has parent & child relationship betwee two tables. foreignkey resides in child table which reference the parent table.

suganthi

• Sep 23rd, 2005

In RDBMS the relationship between the two tables is represented as Primary key and foreign key relationship.Wheras the primary key table is the parent table and foreignkey table is the child table.The criteria for both the tables is there should be a matching column.

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

karthik

• Jan 18th, 2006

When you use truncate all the space alloted for the records along with records gets deleted and if you use delete only the records are deleted and the space allocated for the records remains unaltered.

Nitin kumar

• Jan 13th, 2006

Truncate :- It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.Delete:- It is DML comma...

Answer Question  Select Best Answer