With out using Funnel Stage, how to populate the data from
different sources to single target
- 12 Answers
- 23875 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sesadri
In sequential Stage keep file method as File Pattern, and provide the file name as File_Name_*.csv and file should have similar naming convention.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between in process and inter process?
What is "fatal error/rdbms code 3996" error?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Difference between sequential file and data set?
Define Data Stage?
What steps should be taken to improve Datastage jobs?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the roundrobin collector?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
how to delete one row in target dataset
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How one source columns or rows to be loaded in to two different tables?
