what is decoding & what is NVL?
Answer / gopichinnu
Decoding means It decodes the expression in the way of
If-then-else structure.
NVL means it provides the value for null values.
EX:NVL(comm,0)
Is This Answer Correct ? | 3 Yes | 2 No |
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Mention how can you connect eme to abinitio server?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
how does deadlock occur?
State the first_defined function with an example?
can we perform checkin and checkout through sandbox?
i have input like this TABA 1 TABA 2 TABA 3 TABA 4 TABB 7 TABB 8 TABC 1 TABC 2 TABC 5 OUT PUT NAME COL1 COL2 COL3 COL4 TABA 1 2 3 4 TABB 7 8 TABC 1 2 5
Explain what is the architecture of abinitio?
What is the best way of creating huge test feeds?
Explain what is sort component in abinitio?
Why might the optimizer use a table scan when an index is available?
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?