Answer Posted / subhash

Lets discuss diff cases:
1. If the two tables having same key column,
then based on that key column we can able join the two
tables. It's horizantal joining.
Ex: Table1 has 10 columns +1Key col
Table2 has 5 columns +1Key col
in target SeqFile we get 10+5+1 columns

2. If the two tables having same metadata,
Then using funnel stage we can perform vertical joining.
whether it may continuous or sequence funnel.
In this case we can add extra columns 'INDICATOR'(1 for
Table1 and 2 for Table2 records in the select query) to
identify records

3. If the two tables not having same metadata & Key column,
We can generate 1 common Key column from Column Generator
Stage- 'DUMMY'(values: 1,2,3,4,...) for 2 tables
Then, we can join based on DUMMY column to get all the
columns from the both tables and load those columns to
SeqFile.

Define APT_CONFIG in Datastage?

1066

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3245

---

What is the differentiate between data file and descriptor file?

1353

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2170

---

what is flow of project?

1992

---

What are the different options associated with dsjob command?

1425

---

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 ?

2015

---

What are the main features of datastage?

1276

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2039

---

In Datastage, how you can fix the truncated data error?

1150

---

Where the datastage stored his repository?

1078

---

Explain datastage architecture?

1390

---

Highlight the main features of datastage?

1155

---

What are routines in datastage?

1322

---

Have you used Unstructured data?

1312

---