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

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

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

What are extract and loading in strategies in ab inito and with what components we extract and load the data?

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