How do u set a default value to a column if the column value
is NULL?
Answer Posted / suresh
in the column extended properties set the desired value if
it is null
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the types of containers in datastage?
What is the purpose of interprocessor stage in server jobs?
Describe the main features of datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is process model?
What are the job parameters?
Does datastage support slowly changing dimensions ?
Why fact table is in normal form?
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
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals