Answer Posted / kumar
Hi,
How you can Update the values by using merge stage?. It is
for joining and merging purpose only
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is apt_config in datastage?
what is the use of materialized view?
how to delete one row in target dataset
What is the difference between datastage and datastage tx?
options available in sequence job to run,validate?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Highlight the main features of datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
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.
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How many types of hash files are there?
Name the different sorting methods in datastage.
On which Dimension Table you implemented SCD Type in your Project
What could be a data source system?
client know skid info?