Explain the functionality of your current project?
What are the features of datastage flow designer?
What are sequencers?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
in oracle target stage when we use load option and when we use upsert option?
how many rows sorted in sort stage by default in server jobs
In which situations we can use normal and sparse lookup stages
which dim, fact tables used in bank domain
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How many Key we can define in remove duplicate stage?
How many types of hash files are there?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Differentiate between operational datastage (ods) and data warehouse?