how to handle null values in sequential file?
Answer / satyanarayana
GO to the Format tab in the sequential file then select the
Field defaults option and then select Null field value
option at right side bottom and then provide the
value...........
Is This Answer Correct ? | 28 Yes | 3 No |
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
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What are the processing stages?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
difference between function and procedure...
If the job aborted in a sequencer, how can we start that from the previews successful job.
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
how can or from where we can get reference data in scd type2 implementation?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,