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 9520I 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 6334if 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?
2173iam 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 8248My 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 11106My 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 13002what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8748i 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 8102eno 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 8149Post New Wipro Data Stage Interview Questions
Explain what is the relation between rxlev [0 to 63] and rxlev [-110 to -47]?
What is $@ in shell?
Can we use include ("xyz.php") two times in a php page "index.php"?
What is the Diesel consumption of 1000 KVA rating DG set at full load?
What if constructor is protected in java?
Please write the name of cakephp database configuration file name and its location?
What is zendauthentication?
what is text? : Sql dba
What are SQL sequences in SAP HANA? What is the difference between CURRVAL and NEXTVAL?
What role does AI play in drone navigation?
What is a schema in oracle?
What is Openspan?
What is rccs?
What are the methods of reduction of harmonic content?
What is a cost object? : co- general controlling