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 7237In 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 6323Can 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 4099my 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 9346guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
2 7693How 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 8017I 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 4127I 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 7521Post New TCS Data Stage Interview Questions
"Closed Period" method. our current company method of accounting is called the "OPEN PERIOD". It's time we'd like to use the "CLOSED PERIOD". What is the standard timing and detailed procedure for closed period most of the company have been used. Please advise. thanks.
What is the difference between webforms and mvc?
What does the term "green architecture" mean? : .NET Architecture
Can you automate a process completely using automation anywhere?
Can I integrate a data quality solution within other software applications?
How to run database Query on WordPress?
What is isset post?
Explain about post-relational databases?
Where is regression in excel?
Is mongodb a server?
What Do You Understand By A List Group In Bootstrap And Its Use?
Explain Openpages Regulatory Compliance Management?
Describe a time when you anticipated potential problems and developed Preventive measures
can external audit be seen as merely an overhead cost adding no value to the orgnisation
What is the difference between keyword and identifier?