How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
CTS,
2979How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
3 10333What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
1 20306My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
2 10102hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
2413file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
5 12014Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 25283Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
IBM,
1 7854I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
5 10956Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
HCL,
3 9967My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
6 11083
describe the Steps to confiure a Qlogic switch
What are the processing stages?
Can you explain kafka connector?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How do you run datastage job from the command line?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is meta stage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
how to export or import the jobs in .ISX file
If you want to use the same piece of code in different jobs, how will you achieve it?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Define Merge?
What is active and passive stage?
What is the roundrobin collector?
What is the difference between hashfile and sequential file?
