kv


{ City }
< Country > india
* Profession *
User No # 116509
Total Questions Posted # 1
Total Answers Posted # 10

Total Answers Posted for My Questions # 1
Total Views for My Questions # 17505

Users Marked my Answers as Correct # 18
Users Marked my Answers as Wrong # 2
Questions / { kv }
Questions Answers Category Views Company eMail

List the various vector functions used in ab initio with syntax.

 1 Ab Initio 17505



Answers / { kv }

Question { EDS, 10975 }

the inputs are 10,20,30,40,50 but the output was comes 0
records,the graph was failed what is bad situation?


Answer

There might be many reasons for this-
1. Input and output dml may not be the same.
2.Data type of the output dml might be different.
3. Error in Mapping
4. Selecting condition.

Is This Answer Correct ?    1 Yes 0 No

Question { 4523 }

How does PBK and Sort component and Join(in memory sort)
work?I mean in the join component i have used In Memory
Sort,so how will it work in terms of performence as
compared with PBKand Sort Component?


Answer

In-mermory sort always is useful for small amount of data to be sorted.
If the imput is already partioned on those keys as mentioned in join then in-memory sort will work incase of small amunt of data.

Is This Answer Correct ?    1 Yes 0 No


Question { IBM, 8472 }

. What is adhoc multifiles? How to use in abinitio graph?


Answer

Adhoc multi files are multi files that are created on the serial path.

Is This Answer Correct ?    0 Yes 0 No

Question { HCL, 5169 }

Why creation of temporary files depends on the value of MAX
CORE


Answer

Max Core value is the size of the specific component. Every component has its specific maxcore value.
Some components create temporary files to store temporary data.
Hence if increase the value of maxcore, the size of temporary files will also be increased utlimately, resulting to either failing the graph for size issue or an unexpected behaviour of the graph.

Is This Answer Correct ?    3 Yes 0 No

Question { HCL, 6978 }

. What is flow buffering ? How it reduces the chances of
having deadlock ?


Answer

Flow Buffering is creating a phase wise graph.

Is This Answer Correct ?    1 Yes 0 No

Question { 3640 }

I have a DML in my local system the location is
E:/u/home/khaleel/dml how to convert this path to $DML?


Answer

You can make use of winscp tool to copy the dml from local path to the home path and from home path cp it to the common dml path

Is This Answer Correct ?    1 Yes 0 No

Question { TCS, 7604 }

How to create project (public,private,common,client) what are
the differences between them?


Answer

Common Objects: They are objects which can be used in any of the sandboxes within that workspace.
Private Objects- They are objects are used within that sandbox

Is This Answer Correct ?    0 Yes 0 No

Question { TCL, 7625 }

How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?


Answer

if the rec file is not present you can check the path on which the temprorary files are created with either .job or with filename.dat.lock creaed by your id and then delete it.

Is This Answer Correct ?    1 Yes 0 No

Question { IBM, 9559 }

How you can generate surrogate key? How to use in abinitio graph?


Answer

you can also make use of assign key component.

Is This Answer Correct ?    2 Yes 0 No

Question { 17505 }

List the various vector functions used in ab initio with syntax.


Answer

vector_append(), vector_concat, vector_sort etc.. Please let me know the syntax and more vector functions in ab initio

Is This Answer Correct ?    8 Yes 2 No