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 9771I 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 6512if 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?
2285iam 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 8609My 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 11327My 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 13393what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8911i 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 8458eno 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 8431Post New Wipro Data Stage Interview Questions
where solid grounding and where grounding through ngr done and why?
What is polymorphism used for?
What is incompatible types in java?
Is 2 gb ram enough for windows 7?
How to make any others pages to front page in wordpress?
what is your goal in life?
Tell us about a situation in which you took the extra step for a patient.
What is replication in sybase?
What access modifiers can be used for variables?
What new can you bring on board to our company?
How will you Engage Labours on Site?
what is your usual role in a team?
What are the different principles involved in natural science?
How is a type of file defined in the jcl that executes the cobol program?
What are properties in php?