Answer Posted / anvesh vuppu

You will be having an indicator field(sth like
record_indicator which will identify whether the record is
a header or trailer or detailed.) in your DML. So, use a
partion by expression component in your graph and based on
the indicator values, separate the records.

i.e. give the expression in the PBE component sth like:

if(record_indicator == "H") 0 else if(record_indicator
== "T") 1 else 2;

What are the fundamental blocks of co> operating system of ab initio?

1307

---

Mention what is abinitio?

1044

---

What is the importance of eme in abinitio?

1184

---

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

2389

---

What are the factors on which storage of data depends?

1202

---

What is de-partition in abinitio?

1417

---

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

1219

---

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

1406

---

Where $mpjret is used in ab-initio?

1190

---

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1052

---

Is data warehousing different from data mining?

1142

---

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1807

---

What is the difference between a scan component and a rollup component?

1229

---

What parallelisms does Abinitio support?

1258

---

List out the file extensions used in abinitio?

1127

---