Answer / ramana

While extracting the US rate data from the table create 4
new columns(in the select query itself), which are the
distinct columns from the other 2 databases and a new
column FLAG set it to the value to indicate the country.

Continue the above process to the other 2 countries. Then
you will get a consolidated meta data for all the 3
countries. Then funnel those 3 streams into one and load it
into the target table.

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

What are datastage sequences?

0 Answers  

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

Tell me the syntax of Configuration file?

1 Answers  

---

How to clean the datastage repository?

0 Answers  

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

Can you explain repository tables in datastage?

0 Answers  

---

Have you used Unstructured data?

0 Answers   CTS,

---