how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
1 5772when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
4 23611
How a routine is called in datastage job?
table actions available in oracle connector?
What are orabulk and bcp stages?
What is the difference between hashfile and sequential file?
Define Merge?
How do you import and export data into datastage?
What is the difference between an operational datastage and a data warehouse?
how to export or import the jobs in .ISX file
How to perform incremental load in datastage?
In Datastage, how you can fix the truncated data error?
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)
AGGREGATOR default datatype
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
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 is ibm datastage flow designer?