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 6183

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 5684

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 3205

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

 2837

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

 5 42853

how to sort two columns in single job in datastage.

 1 10191

how to sort two columns in single job in datastage.

 2527

how to sort two columns in single job in datastage.

 1 7204

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 8257

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

 2 6552

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 7109

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

 1 6079

Difference between the Sequence and Sequencer in DS?

 1 11086

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 3464

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 6431

Post New TCS Data Stage Interview Questions


TCS Data Stage Interview Questions


Un-Answered Questions

Name the types of tunable consistency?

60

What is dao recordset?

1

Are you comfortable with relocation?

677

give me some advantages of django over using other frameworks?

207

Why do you wish to join our company?

709




How do I count rows quickly in excel?

298

Why do we need ms powerpoint?

105

Is it possible to insert comments into sql statements return in the data model editor ?

2061

Explain about different types of recorders available in automation anywhere?

38

Find out BEP(Rupees) when p/v ratio is 40% , MOS is 30%. Profit is Rs 12000

1115

do you have plans for any further studies?

692

Explain the features of java?

585

How do you generate reports in treasury? What format are they generated in?

1713

Explain the two ways used to create asset masters? : fi- asset accounting

600

What are mttr and mtbr reports?

569