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 components of datastage?

1123

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1118

---

describe the Steps to confiure a Qlogic switch

2385

---

AGGREGATOR default datatype

1463

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1544

---

Where the datastage stored his repository?

1089

---

what is the use of surogate key in datastage

2312

---

Nls stands for what in datastage?

1192

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2066

---

What are the different plug-ins stages used in your projects?

1078

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2483

---

What is aggtorec restructure operator?

1457

---

Difference between in process and inter process?

1242

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2974

---

What is the method of removing duplicates, without the remove duplicate stage?

1029

---