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 9661I 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 6423if 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?
2239iam 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 8433My 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 11222My 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 13243what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8836i 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 8303eno 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 8297Post New Wipro Data Stage Interview Questions
How to select 10 records from a table?
What is pg_hba conf file?
What is double exclamation point?
How to add custom php codes in my drupal pages or blocks?
Why widget does not show up in the sidebar?
What are the 5 r's of managing behaviors?
What are the services provided by Session layer?
What is data source document?
What are the properties of datacontrol?
Is there a version of Merge for Mac OS X?
Company A from Maharashtra dispatch material directly to company C in Maharashtra & Billed to Company B in Karnataka. Co. A raised billed to Co. B charged local VAT., Co. B raised bill on Co. C tax rate NIL. Can Co. C claimed on VAT amount ?
which type of instrument included in plumbing work?name of instrument?
What is partnership marketing?
How to get data from the velocity page in a action class?
What is the primary use of normalization?