prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 13th, 2006

.profile is a file which gets executed automatically when that particular user logging in.you can change your .profile file to include any commands that you want to execute whenever u logging in.you c...

Answer Question  Select Best Answer

dontbuckme

 Profile Answers by dontbuckme Questions by dontbuckme

• Sep 22nd, 2006

Don't think this question is appropiate for interview......may be just because I don't know the answer  :)

Answer Question  Select Best Answer

ak

• Sep 7th, 2006

Use m_mkdir command to add more directories to the already existing directory structure.

Answer Question  Select Best Answer

madhurima

• Aug 17th, 2006

Dependency analysis will answer the questions regarding datalinage.that is where does the data come from,what applications prodeuce and depend on this data etc..

Answer Question  Select Best Answer

Kannan

• Sep 8th, 2006

Hi All,You can pass the i/p file name as parameter using Graph level parameter which is for particularly first graph if this graph only using that input file and another parameter file for another gra...

Answer Question  Select Best Answer

Vishal

• Sep 3rd, 2006

First of all define a "Formal" Keyword Parameter of type string.   e.g Let us say you defined paramter by name "FilterCondition". And you want your filter to be "COUNT > 0"Now on your com...

Answer Question  Select Best Answer

dontbuckme

 Profile Answers by dontbuckme Questions by dontbuckme

• Sep 22nd, 2006

pros: easy and save development timecons: need to understand how to feed the parameters, and you can't control it easily :)

Answer Question  Select Best Answer

What will happen when we pass dot or invlaid parameters in the inout component layout URL?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Hi,I myself found the answer.If the environment parameters are not set, we get this error.--Anne

Answer Question  Select Best Answer

After developing the graph what are the step involved to load the EME?

nagarjuna

• Jul 22nd, 2011

After developing graph save it. Automatically it will generate .ksh, .db, .mp, .xfr, .dml.

If you want to send the saved or latest version of the graph you can go for check in option in GDE or From UNIX you can go for EXPORT.

Answer Question  Select Best Answer

Hi,Can anyone explain how XML reformat is being used to generate XML file.Please let me know with one example.Suppose we have three records in the input file as below:XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3PPP,006,Company_2 where XXX- name001 - Emp IdCompany_1 - Company nameCan anyone help me out to explain the generation of XML using this example.

srihari_vsn

 Profile Answers by srihari_vsn Questions by srihari_vsn

• Jun 20th, 2011

Hi,Let the input file data be as below.PPP,006,Company_2XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3Let the record format for reading this data be as below.recordstring(",") Name;deci...

Answer Question  Select Best Answer

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by siva sankar pulivarthi

• Feb 9th, 2012

In Abinitio, we have Multifile System. Multifiles are like different partitions of an original file. For example, if we take a 4 way partition file, which implies, data of an original file is stored i...

Answer Question  Select Best Answer

Ashim Dutta

• Mar 20th, 2006

Thanks to Ashim for more clarification...**********************************I have talked about a situation where you have linked2 components - each of them having different layouts.Think about a situa...

Ashim Dutta

• Jul 10th, 2005

ashimdutta@yahoo.com  When two components are linked together if their layout doesnot match then this problem can occur during the compilation of the graph. A solution to this problem would be to use a partitioning component in between if there was change in layout.

Answer Question  Select Best Answer

kalyan

• Mar 16th, 2006

This is a tricky question, number of component in a graph has nothing to do with the level of knowledge a person has. On the contrary, a proper standardized and modular parametric approach will reduce...

SandeepSingh

• Sep 5th, 2005

It depends the type of components you us.   usually avoid using much complicated transform function in a graph.

Answer Question  Select Best Answer

rajraku

 Profile Answers by rajraku Questions by rajraku

• Jan 23rd, 2008

While creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table.....................

Answer Question  Select Best Answer

janshi

• Dec 27th, 2021

These are the temporary table created by sql server. When any new entry is added in main table then this entry also goes to the inserted table, similarly if any record is deleted from main table then this will go to deleted table.

Answer Question  Select Best Answer

Subhra Dhar

 Profile Answers by Subhra Dhar Questions by Subhra Dhar

• Mar 25th, 2009

By checking the execution plan of the query after doing each modification and determining the cost of the query.

Answer Question  Select Best Answer

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 12th, 2014

If the stats are not collected on the table the index info is not available in the data dictionary, ,In such case the optimizer would pick up the full table scan instead of using the indexes. In order to always use the indexes we can give the hint to oracle to always use the index.

Answer Question  Select Best Answer

PeeD1

 Profile Answers by PeeD1 Questions by PeeD1

• Apr 17th, 2009

The following are some possible strategies for dealing with this problem: 1) If a job does a bulk load into a table and you know the table was empty before the job began, you can truncate the table be...

Answer Question  Select Best Answer

seemabuchhada

 Profile Answers by seemabuchhada Questions by seemabuchhada

• Mar 14th, 2014

1: Analyzing execution plans
2: Try to minimize the number of subquery block in your query.

Answer Question  Select Best Answer

mudassir01

 Profile Answers by mudassir01 Questions by mudassir01

• Jul 19th, 2009

1) Space 2) Server Utilisation3) Any script running taking lots of time

Answer Question  Select Best Answer