How to convert RGB Value to Hexadecimal values in datastage?
whom do you report?
What are some prerequisites for datastage?
What is the default execution order of the sequential file?
Define orabulk and bcp stages?
What are stage variables, derivations and constants?
Why we need datasets ratherthan sequential files?
how can you generate sequence number using only the sequential file stage?
Describe link sort?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what are the types of nodes