-
Query transform and SQl transform
What is the difference between Query transform and SQl transform in BODI?
-
What is the difference between lookup(0 and lookup_ext()..
What is the difference between lookup(0 and lookup_ext() functions in BODI?
-
How do you implement Full outer join
How we will implement Full outer join in BODI?Explain with some examples?
-
What is the use of clear status file
What is the use of clear status file in DS?How we will use it?explain with examples?
-
How you will define Global
How you will define global variables in DS?
-
When we have to contact with admin people...
Have you ever contact with the DS Administration people?What are the situations and what problems you phased?
-
How do you implement SCD in Datastage
How we will implement scd in DS?Explain with example ?Any scd ie scd1,scd2,scd3 .
-
How can we load the flat file
How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side.