Output for sort and dedupsort with NULL key?

Answer Posted / ar

It will treat all the columns as part of key. In the key
parameter you have to mention "{}" to make it as a NULL key.
If all the column values for two consecutive records are
same, then only it will dedup or it will send all the
records to output port.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the facts that can compromise data integrity?

741


What are the Types of parallelism in detail?

788


State the relation between EME, GDE and Co-operating system?

771


Explain data flow graph with an example?

725


Describe what the SQL Server tempdb and tlog files are used for?

1914






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

813


What is the difference between rollup and scan?

1407


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

678


Explain the difference between the truncate and delete commands?

715


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?

3997


What is common among data validity and data integrity?

682


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

835


How do you truncate a table?

776


What is sandbox?

818


What is m_dump?

835