Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
1 6018How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
IBM,
1 5561i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 16936how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
2 8716In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
TCS,
1 5714Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
TCS,
1 3250
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain the situation where you have applied SCD in your project?
How we can covert server job to a parallel job?
What is difference between server jobs & parallel jobs?
Describe link sort?
What are the primary usages of datastage tool?
What is staging variable?
Is possible to create skid in dim,fact tables?
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...
how to export or import the jobs in .ISX file
What is the difference between hashfile and sequential file?
Differentiate between data file and descriptor file?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the different common services in datastage?
What is the precedence of stage variables,derivations, and constraints?