in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
2 9664I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
2 6426if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
2240iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
4 8443My 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 11226My 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 13257what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8839i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
4 8311eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
4 8304Post New Wipro Data Stage Interview Questions
What is the use of keywords in java?
What is protocol testing?
What are signals in Django ?
What are the differences between Smilodon Tini and Smilodon Fatalis?
What is hierarchical relationship in SFDC?
How to create a console application in Kylix?
What is the use of garbage collection?
Is there any circumstance where an accountant is allowed to depart from accounting standards while preparing financial statements? If yes explain why, if no explain no.
How to access config variable in codeigniter?
What is process studio in blue prism?
What is different type of rman backup?
Explain what are the think-time functions?
How many structures are there?
Can the nested class access, the containing class. Give an example?
Explain the use of parfile option in exp command.