Interested to Buy Any Domain ? << Click Here >> for more details...
diff between changecapture & diffrence stage which situvation
we can use the diffrence stage ?
- 1 Answers
- 4117 Views
- TCS, I also Faced
- E-Mail Answers
Answer / sindhu
both are used to used to compare the data between after and before data difference between them difference data does not generate data regarding to after data suppose if new record is inserted in after data it just gives code to it it will not display in the output
| Is This Answer Correct ? | 2 Yes | 0 No |
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is staging variable?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What is the purpose of pivot stage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
What are the various kinds of the hash file?
Teradata 
