Wat is pre-load in Hashed file
Answer / mobashshar
you can speed up the read operation of reference hash file
link by pre loading the hash file in memory.
| Is This Answer Correct ? | 7 Yes | 0 No |
Differentiate between Join, Merge and Lookup stage?
why do u need the IOS upgradation in a FC switch
What is the difference b/w Hash file and Lookup Fileset stages?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
What is Horizontal transformation, vertical transformation,diagonal transformation?
What are the types of hashed files in data stage
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
what is 'reconsideration error' and how can i respond to this error and how to debug this
where we use column generator stage in real time scenario?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.