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

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

1741

---

What is the difference between rollup and scan?

1929

---

What do you understand by overflow errors?

1297

---

When we should use 'jobid' for commit table (Output table component??

9206

---

Where $mpjret is used in ab-initio?

1190

---

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1309

---

Explain batch processing in ab initio?

1494

---

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

---

What exactly do you know about the typical data analysis?

1151

---

How to add default rules in transformer?

1262

---

How co> operating system natively processes the data?

1139

---

What is the difference between partitioning with key / hash and round robin?

1472

---

How do you truncate a table?

1214

---

What are the benefits of data analyzing?

1232

---

What do you mean by a transaction file?

1301

---