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.
Answer Posted / ashok
4.in case of only for duplicates removing i will use remove
duplicate stage.but in case of more logics applied i will
go to transformer.bcoz remove duplicate stage give better
performance compare to transformer
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
If you want to use the same piece of code in different jobs, how will you achieve it?
What is difference between join, merge and lookup stage?
What is difference between symmetric multiprocessing and massive parallel processing?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is the difference between == and eq in UNIX shell scripting?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are sequencers?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
project Steps,hits, Project level HArd things,Solved methods?
What are transforms and what is the differenece between routines and transforms?
Describe stream connector?
Name the command line functions to import and export the DS jobs?
Define meta stage?
Differentiate between hash file and sequential file?