how can we validate the flat files using the date in the
header and number of records in the flat file? Using both
conditions at a time.
No Answer is Posted For this Question
Be the First to Post Answer
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
How can we select pr retrieve the particular row in dataset by using orchadmin command?
what is diff b/w datastage 8.1,8.5,8.7?
Differentiate between data file and descriptor file?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
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
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
what is mapping lookup
How a source file is populated?