Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Every one,
I have a scenario plz suggest me
1)On daily we r getting some huge files data so all files
metadata is same we have to load in to target table how we
can load?
2) One column having 10 records at run time we have to send
5th and 6th record to target at run time how we can send?
Hi plz help me for above scenarios and If any one is having
JobSequence kindly send me one example and the scenario to
my mail ID(nrvdwh@gmail.com)
- 3 Answers
- 10217 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijayreddy
Hi Please find the dfd
seqfile--->T/R--->filter---->ds
in T/R stage u can take one etc column(SEQNO)that u can pass to next stage at same time u can create two stage varibles(sno1,sno2) this stage varibles u can call the filter stage in where class like(SEQNO between #sno1# and #sno2#
& then u can run job .That parameters values run time u can give the recored
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akila ramu
Sample stage can be used for this. Sample stage when run in
period mode and N is mentioned, every Nth record from the
input is sent to the output.
For eg., period number=5 and maximum value=20 then 5, 10,
15 and 20th records are alone sent to the output.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ankit gosain
Hi All,
Ans1: In the source sequential file, you can specify the
read method from specific file to file pattern, so that it
can take the file on daily basis.
like:-you are getting the files ALSSM_12122012.dat,
ALSSM_13122012.dat, ALSSM_14122012.dat and so on which is
just appended by the date with file name. for this, you can
specify a file pattern like <path>/ALSSM_*.dat
Ans2: SeqFile--->Transformer--->Tgt
create two parameters of integer type in your job (say Val1
& Val2) &
In transformer stage, define a constraint:
@INROWNUM=Val1 OR @INROWNUM=Val2 (Where @INROWNUM is a
System Variable). Now you can assign the value of Val1 &
Val2 at the run time.
For more queries, mail me on ankitgosain@gmail.com
Cheers,
Ankit :)
| Is This Answer Correct ? | 2 Yes | 2 No |
how can find maximum salary by using Remove duplicate stage?
how to find out number of records imported into source file?
what is the use of DSattchJob?DetachJob? where can we find it?
Can you highlight the main features of ibm infosphere information server?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
What are transforms and what is the differenece between routines and transforms?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
How to get max salary of an organization using data stage stages........... can any body help me plz.......
where we use config file as parameter ?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Teradata 
