Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

TCS Data Stage Interview Questions
Questions Answers Views Company eMail

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 4351

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 4428

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 1871

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?


what is the exact difference between dataset and fileset in datastage?

5 32721

how to sort two columns in single job in datastage.

1 7636

how to sort two columns in single job in datastage.


how to sort two columns in single job in datastage.

1 5837

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 6328

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 4776

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 5497

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 4789

Difference between the Sequence and Sequencer in DS?

1 8865

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 2034

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer

2 4733

Post New TCS Data Stage Interview Questions

TCS Data Stage Interview Questions

Un-Answered Questions

What will be advantage if we put some load in neutral of grounded star transformer & loadshortcircuit current,rated current of cable & MCB with example?


What is Video Conferencing ?


What is demand promissory note?


What is the command in bteq to check for session settings ?


You can roll a dice three times. You will be given $X where X is the highest roll you get. You can choose to stop rolling at any time (example, if you roll a 6 on the first roll, you can stop). What is your expected pay-out?


How do you check the installed software components and product versions on sap system?


What is difference between window & a page window?


Can we use tensorflow for machine leanring ?


what is civil engineer greatest strength and weakness?


Why did they used to make the mill chimneys so tall?


What are SQL sequences in SAP HANA? What is the difference between CURRVAL and NEXTVAL?


Which register which contains the instruction that is to be executed?


The following program reads data (details of students) from a file named students.txt and converts it into e-mail addresses. The results are written to a file named studentemail.txt. students.txt consists of a number of lines, each containing the data of a student in colon delimited format: Last Name:First Name:Student Number Each input record is converted to an e-mail address and written to studentemail.txt in the following format: the first character of the last name + the first character of the first name + the last four digits of the student number + “” import*; public class EmailConverter { public static void main(String[] args) throws IOException { BufferedReader input = new BufferedReader(new FileReader ("students.txt")); PrintWriter output = new PrintWriter(new FileWriter ("studentemail.txt")); String line = input.readLine(); while (line != null) { // Extract the information for each student String[] items = line.split(":"); // Generate the email address String email = "" + items[0].charAt(0) + items[1].charAt(0) + items[2].substring(4,8) + ""; email = email.toLowerCase(); // Output output.println(email); line = input.readLine(); } input.close(); output.close(); } } Rewrite the class so that it handles possible errors that may occur. In particular, it should do the following: • It should catch at least three appropriate exceptions that might occur, and display suitable messages. • At this stage, the program will not run correctly if there is an empty line in the input file. Change the program so that if an empty line is encountered, an exception is thrown and the empty line is ignored. This exception should be handled with the display of a suitable error message. • Before the e-mail address is added to the output file, check if the student number has 8 digits. If not, throw an InvalidFormatException (which the program should not handle itself)


where can we change the number, currency and time formats?


How would you handle the extreme pressure during emergency situation if you know that plane is not safe and it might crash anytime?