Thursday 1 March 2012

jde interview questions_part6

1.what is table conversion?

 is a type of batch process that enables you to rapidly manipulate the data in tables

2.what type of conversions you can do in TC

data conversions,data copy,data copy with table input ,batch delete


data conversions:  enables you to transfer or copy data from an input table  or business view into output tables using to logic.this is necessary to perform the transfer .you can also use data conversion to update records in a table or business view
data copy :  enables you to copy tables from one data source or environment to another source or environment .when the tables are identical
data copy with table input: enables you to copy tables based on information from an input table .for example the input table provide information about which tables are copied when they are copied and so on
batch delete: enables you to delete records from a table or business view

3.what is table conversion process flow?

data copy : the conversion type does not include input and out put tables.all actions are accomplished through the process begin event.

data copy with table input: the conversion type does not include output table .all actions are accomplished through the process begin,process end and row fetched event


batch delete: as with the data copy with table input type. the conversion type does not include output table .all actions are accomplished through the process begin,process end and row fetched event


4.how many inputs a TC can have?


one


5.what is foreign table?


Non - JDE  table are called foreign table not defined by one world


6.what is difference between fetch single and select, fetch next?


fetch single retrieves only a single row(based on primary index)and select fetch next retrieves more than one record

7.how many out puts can be attached in a batch delete?

none

8.what is flow of events in TC?
process begin,data changed,row fetched,format fetched,and process end

9.what is difference between user insert row and   TC insert row?


a user insert row can defined  anywhere but TC insert has to be defined at the end of the event


10.what is a processing option and where do you attach it in a TC?

 it is a run time user input and you attach po in the external data of the navigation window

11.What is table conversion system functions?

Tc insert row
User insert row
Set selection append flag
Set user selection
Stop conversion processing
Stop event processing
copy table data source
Copy table data invironment


No comments:

Post a Comment