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 8415I 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 5405if 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?
1749iam 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 7019My 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 10101My 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 11082what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 7994i 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 6685eno 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 6742Post New Wipro Data Stage Interview Questions
How will you measure the eccentricity of the turbine rotor during running
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Explain the reproductive strategies and processes observed in Acoelomates.
How do you use the append function in excel?
Explain what does mvc represent in asp.net? : asp.net mvc
Describe the approach to diagnosing and treating amblyopia (lazy eye) in pediatric patients.
What is the default scope of bean in spring framework?
What is wpf and why it is used?
What are the main organizational functions of personnel sub area?
Explain why does a glacier move?
What do you know about OROP?
What is the objective of regression testing?
how to use C++?
How do you interact with friends ?
What type of architecture is used in 8085 microprocessor?