Interested to Buy Any Domain ? << Click Here >> for more details...
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
2106what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
TCS,
1 7227cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
TCS,
3 8227Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
IBM,
1 4310Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
IBM,
7 13134Hi, 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.
CGI,
1 5737i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
IBM,
2 14348I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
CGI,
1 5608Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
TCS,
3 18724
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Which algorithm you used for your hashfile?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Define oconv () and iconv () functions in datastage?
what is the use of surogate key in datastage
What are the various kinds of containers available in datastage?
Define ds designer?
What all the types of jobs you developed?
Explain the importance of surrogate key in data warehousing?
CHANGE CAPTURE
Describe routines in datastage? Enlist various types of routines.
whom do you report?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
State the difference between an operational datastage and a data warehouse?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
