What is the Disadvantage of surrogate key stage?
Latest Answer: to my concern if the data is not properly processed on nodes..in such suitations this surrogate key generates holes(simply skips the ordering )ex:aa-1bb-2ba..bg...cc-3dd-4ddd-5here for ba and bg do not have seq key ,here ba and bg have holes ...
how to find out individual counts for a particular table
Latest Answer: while implementing the scd type-2, due to maintianing of history, the primary key constraint will be violated. to have a primary key for the table for the sake of unique key we use surrogate key. ...
Any body explain the flow of project(parallel) in real time thanx
Latest Answer: Project flow is nothing but the data flow in your project. For example in many of the projects data is moved from source to staging, and then perfoem ETL and staging to ware house. So here you encountered 2 levels of data flow i.e source to ...
1. Is the Hash file is active or passive? If we take as source ?2. can u take seq file as look up?3. In hash file dynamic 30, there r two types:1)genaric2)specific what is the meaning?4. how to connect
Latest Answer: 34th Question:By killing process id in server console we can release the job. ...
write the shell script using Unix to run the 2 jobs?How to schedule the 2 jobs using Unix crontab to run for particular time?
At the time to incremental loading I need to take the reusable files' path in this situation How to assign the one path of file to PROJDEF using the job parameters?
what is process to remove duplicate records using Copy Stage.
Latest Answer: In the copy stage, there is an option to sort the input data where you can select the key on the basis of which you can perform the sort operation. There is an option named 'Unique'. Select this, it will return the unique record after the sort ...
If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why
Latest Answer: use the lookup stage when the reference table size is less relative to physical ram memoryif the reference table size is too big then data stage recommends to use the join stage to speed up the join process ...
What is the use of clear status file in DS?How we will use it?explain with examples?
Latest Answer: When you clear a job’s status file you reset the status records associated with all stages in that job. You should therefore use this option with great care, and only when you believe a job has hung or aborted. In particular, before you clear a ...
How you will define global variables in DS?
Latest Answer: The user variable stage allows you to define global variables within a sequence. These variables can then be used elsewhere in the sequence,The values of the user variables are set by expressions in the stage’s properties ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
