Answer Posted / ijaz

Sort component. Because it chance the order by data by ascending,descending orders.

Describe what the SQL Server tempdb and tlog files are used for?

2294

---

Explain how abinitio eme is segregated?

1448

---

State the relation between EME, GDE and Co-operating system?

1083

---

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1619

---

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1062

---

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1113

---

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4359

---

What is the purpose of having stored procedures in a database?

1114

---

What kind of layouts does abinitio support?

1230

---

Explain what does dependency analysis mean in abinitio?

1086

---

What information does a .dbc file extension provides to connect to the database?

1191

---

What do you know about partition and also tell us about partition components in abinitio?

1025

---

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1100

---

explain checkin and checkout?

1103

---

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

3956

---