In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the difference between an operational datastage and a data warehouse?
How to reverse the string using SQL?
What is a quality stage?
How many nodes supported by a one cpu in parallel jobs?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the use of surrogate key stage?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Differentiate between odbc and drs stage?
which memory is used by lookup and join
how to export or import the jobs in .ISX file
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