Answer Posted / aditya

There are numerous string functions like :

char_string
decimal_lpad
decimal_lrepad
decimal_strip
is_blank
re_replace
re_replace_first
string_char
string_compare
string_concat
string_filter
string_filter_out
string_join
string_length
string_lpad
string_lrepad
string_lrtrim
string_ltrim
string_pad
string_replace
string_replace_first
string_split
string_substring
string_to_hex
string_trim

and many more

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1053

---

What would be the next step after collecting the data?

1198

---

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1144

---

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

1058

---

How is the partitioning with key different from round robin partition?

1218

---

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1037

---

What are the functions of the replicate and dedup component?

1092

---

What are the various types of layout supported by abinitio?

1032

---

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

2064

---

How would you find out whether a sql query is using the indices you expect?

1073

---

What are “business rules” in ab initio business rules environment (bre)?

2023

---

What are the different types of parallelism in ab initio?

1222

---

Pdl with an example?

1113

---

What is air-project parameter ?

2228

---

What is data encoding?

1264

---