What is regex (lookup)? When you should use it?
Answer Posted / ramakrishna
lookup is also similar to join.. by using the following
syntax we will fetch the info from lookup
lookp("looupfilename",conidition).field want to fecth from
lookup
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
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?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What are the differences between different versions of co-op?
What is sort component in abinitio?
What do you mean by the term data warehousing?
How to move or copy the project parameter or project object to my sandbox?
Describe the evaluation of parameters order in ab initio?
What is the function that transfers a string into a decimal?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
Describe the grant/revoke ddl facility and how it is implemented?
Mention what dedup-component and replicate component does?
How co> operating system natively processes the data?
What is data mapping and data modelling?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
How do you truncate a table?