Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prashant jaiswal
To explain with example, If you have 10 records with dedupe
key having values of 10,10,20,30,30,30,30,40,40,50. On
deduping UNIQUE, you will get 20 & 50 in your output.
Remaning records comes out in the dup port.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are the key elements of a data processing system?
What is ab initio enterprise meta>environment (eme)?
What do you mean by data sorting?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
Describe what the SQL Server tempdb and tlog files are used for?
what is the difference between i)public ii)private iii)common and client projects?
What is the difference between a scan component and a rollup component?
what is the project environment(for each project the environment is same or different to different project)?
Why might you create a stored procedure with the with recompile option?
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?
Have you used rollup component? Describe how.
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
Explain the ab initio etl tool in high level?
What the difference between “look-up” file and “look is up” in abinitio?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
