Answer Posted / babu

Hi Teja,
The two sources are haveing same structure,so beter to
use list file,to load the data into single TARGET.

Procedure:
----------
1.Place the two source paths in a note pad and
save as it '.list' format.
2.create a maping as per your requirement in
that mapping you have to take only one source no need to
take two sources.
3. Create a session and workflow.
4.In session give a SOURCE FILE PATH
is '.list' file and SOURCE FILE TYPEA as INDIRECT.

Let me know if any thing wrong.

Thanks,
dwarak.vbr@gmail.com

How to partition the Session?

1040

---

Define joiner transformation?

986

---

Describe data concatenation?

1005

---

Write the advantages of partitioning a session?

1203

---

What is different between the data warehouse and data mart?

1001

---

What is event and what are the tasks related to it?

1054

---

What do you understand by term role-playing dimension?

982

---

How many numbers of sessions can one group in batches?

1013

---

What is Index Caches size?

1055

---

design of staging area?

1964

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6910

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

difference between repository database and repository service?

1081

---

How do you migrate data from one environment to another?

1042

---