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 what the SQL Server tempdb and tlog files are used for?

2269

---

Pdl with an example?

1047

---

What are the different types of parallelism used in abinitio?

1040

---

Why do you think data processing is important?

1060

---

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

1169

---

How co> operating system natively processes the data?

1028

---

What is $mpjret?

1075

---

What kind of layouts does abinitio support?

1193

---

What does de-partition mean in abinitio?

1208

---

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

941

---

What do you understand by a cartesian join?

1051

---

What parallelisms does Abinitio support?

1146

---

Have you ever encountered an error called “depth not equal”?

1106

---

What are the various types of layout supported by abinitio?

959

---

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1056

---