Answer Posted / venugopal

Hi Kiran,

We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.

let me explain

In the source file path uu can mention process date and
file name with *.txt extension
For Ex:
#SRC_DATA_DIR#/JD/incoming/intermediate/*#PROC_DT#_SHIPMENT*
.txt

Above path PROC_DT is process date and SHIPMENT is file
name

Now the data can be retrieved from multiple files and
populated into a single file.

Hopes this will help you Kiran.

Any Doubts cal on 09767117168

What are the various kinds of containers available in datastage?

1048

---

which r the connectors used in san?

2188

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

---

describe the Steps to confiure a Qlogic switch

2383

---

Define project in datastage?

1093

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3754

---

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

2722

---

Which algorithm you used for your hashfile?

1180

---

How do you remove duplicate values in datastage?

1151

---

What are stage variables and constants?

1147

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

Name the different sorting methods in datastage.

1049

---

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.

3345

---

What is the difference between account and directory options ?

1182

---

What are the partitioning techniques available in link partitioner?

2277

---