TCS Data Stage Interview Questions Answers, TCS Placement Papers, TCS Technical, HR Interview Questions, TCS Aptitude Test Questions, TCS Campus Placements Exam Questions

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 7351

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 6427

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 4239

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

3250

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

5 45864

how to sort two columns in single job in datastage.

1 11080

how to sort two columns in single job in datastage.

2905

how to sort two columns in single job in datastage.

1 7941

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 9507

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

2 7795

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 8133

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

1 6876

Difference between the Sequence and Sequencer in DS?

1 11913

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 4236

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

2 7661

Post New TCS Data Stage Interview Questions

TCS Data Stage Interview Questions

TCS Data Stage Interview Questions (90)

Un-Answered Questions

Are there any practical applications of Quantum AI today?

What is the use of the migration assistant tool in azure websites?

617

List two java ide’s?

1051

What is a caas?

782

States some of the tool bars used in cad?

1207

Is java swing deprecated?

1115

What happens Update command is used without where clause ?

1184

How do I see environment variables in windows?

827

How to remove duplicate values from a PHP Array?

1089

Are all the hook methods available to all the controllers?

268

i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression

1465

What is the purpose of a query?

929

Cheque rs 1400 received from Charles in settlement of a debit of rs 1500 returned dishonored

995

How to delete a batch?

1144

Explain the use of indexes option in exp command.

1150