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 5829
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 5413
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 arises1 2883
what is the exact difference between dataset and fileset in datastage?5 41085
how to sort two columns in single job in datastage.1 9797
how to sort two columns in single job in datastage.1 6926
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 7877
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.2 6138
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 6731
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?1 5856
Difference between the Sequence and Sequencer in DS?1 10769
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 3170
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer firstname.lastname@example.org 6011
Post New TCS Data Stage Interview Questions
Explain a high level steps to integrate a search engine (solr, endeca, gcs etc) with hybris?
What is data encapsulation in objective-c?
What is support, env.rb and hooks.rb?
For 65hp motors how kvr capacitor should be on??
Is it important for Hadoop MapReduce jobs to be written in Java?
How does a block is recognized in the Blockchain approach?
What is platformbrowserdynamic?
Short Answer on -----Trade mark
What does stand for?
What is a template on a website?
What are the disadvantages of angularjs?
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
Can you split a cell in excel 2016?
What is a user defined variable?
How is the comparison of objects done in php?