What is the difference b/w Hash file and Lookup Fileset stages?
Answer / srinivas
Both the files are used for look up purpose but Hash file is in server edition and witch we don't have in parallel edition.
Same Look up file also existed in parallel not in server edition.
In both files we have to give the key column.
| Is This Answer Correct ? | 2 Yes | 0 No |
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
how to load meta data
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the environmental settings for data stage,while working on parellel jobs?
What are the steps required to kill the job in Datastage?
Triggers,VIEW,Procedures
how to find diff between 2 dates without using Icon... funtions?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
options available in sequence job to run,validate?
how do you pass parameters in a script?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
Define project in datastage?