diff between changecapture & diffrence stage which situvation
we can use the diffrence stage ?
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 |
How to convert alpha Numeric values to alpha using functions?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
what is the use of skid in reporting?
why do we need a datawarehouse when we have databases to store data?
What is usage analysis in datastage?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
Why fact table is in normal form?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
what is the difference between datasatge and datastage TX?
What is the different type of jobs in datastage?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.