how can we create tables in datastage?
Answer / hanug
The DB tables will be created in two ways
1. By right clicking on on the navigator on any of the
folder, you can choose NEW -> Table definition
2. We can also create new table using Database stages.
| Is This Answer Correct ? | 2 Yes | 8 No |
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
how many types of remove the duplicate records?
What are the environmental settings for data stage,while working on parellel jobs?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
how to cleansing data
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
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
How do you load 10 different sources with 10 different layouts to 10 different tables?
how many dimentions and fact tables used in your project and what are names of it?